Filtering in SC Navigator

General

Data filtering is an important feature of SC Navigator, which is supported by filters available on side panels. The page will shown only data for the selected items. For example if only Ankara_LDC is selected on the Warehouse Data page, the tables on the page will shown only data for Ankara_LDC.

../../../../_images/warehouse_filter_example_6.png

Each page contains filters for the data types which are used on it and the shown filters contain only data related that page. For example, on the data page Customer, the Product filter contains only products for which there is demand.

If a data type exists on different pages, the filter is applied to all those pages. For example, if a product is filtered out on the Warehouse data page, it will be filtered out e.g. on Customer page, too. On each filter side panel, the group data is shown in the upper part and single data is shown in the lower part.

On Supplier, Production, Warehouse, and Customer filter side panels you can switch to location view as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Switch to location view option

For example on the Warehouse filter:

../../../../_images/warehouse_filter_example.png

When using the filters the following effects are applied:

  • If a location is selected/unselected the related supplier/production/warehouse/customer is also selected/unselected. For example on the warehouse filter:

  • If a supplier/production/warehouse/customer (supplier/production/warehouse/customer group) is selected/unselected the related location (location group) is also selected/unselected. For example if Ankara_LDC is unselected on the Warehouse filter then it will be unselected on the Warehouse Location filter, and the same is true vice versa:

    ../../../../_images/warehouse_filter_example_2.png
  • If a group data is selected/unselected the single data which belongs to this group is also selected/unselected. For example, if on the Warehouse (Location) filter the group CDC_COG is unselected, the single data COG_Munich_CDC also becomes unselected:

    ../../../../_images/warehouse_filter_example_3.png
  • If a single data is unselected, the group which the single data belongs to is also unselected.

For example, if on the Warehouse (Location) filter the single data Ankara_LDC is unselected, the group LDC also becomes unselected:

../../../../_images/warehouse_filter_example_4.png
  • If all single data in a group is selected, the group is also selected.

For example, if on the Warehouse (Location) filter the single data COG_Katowice_LDC, COG_Lausanne_LDC, COG_Mannheim_LDC is selected, the group LDC_COG also becomes selected:

../../../../_images/warehouse_filter_example_5.png

You can clear all the filters as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Clear all filters option

  3. All the unselected data becomes selected regardless of the type of the filter

../../../../_images/warehouse_filter_example_7.png

Supplier Filters

This side panel contains all the suppliers defined in the input data. There is no supplier group data, but supplier location group does exist, so this side panel looks different from the others.

../../../../_images/supplier_filter.png

Use the checkboxes to filter by Supplier. Only the data of the selected supplier will be displayed on the page.

../../../../_images/supplier_filter_2.png

Without unselected filters, so the table shows data for all supplier

../../../../_images/supplier_filter_3.png

When Antalya_FG is unselected, so the table does not show data for this supplier.

You can switch to the location view as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Switch to location view option

../../../../_images/supplier_filter_location.png

The behavior of the supplier filters is determined by the following:

  • If a location is selected/unselected, then the corresponding supplier is also selected/unselected.

  • If a supplier location group is selected/unselected, then the single supplier locations which belong to that group are also selected/unselected.

  • If a single supplier location is unselected, then the supplier location group which the single supplier location belongs to is also unselected.

  • If all single supplier locations in a location group is selected, then the location group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

Production Filters

This side panel contains all the production facilities defined in the input data.

../../../../_images/production_filter.png

Use the checkboxes to filter by Production. Only the data of the selected production facility will be displayed on the page.

../../../../_images/production_filter_2.png

Without unselected filters, so the table shows data for all production facilities

../../../../_images/production_filter_3.png

When L’Arbresle is unselected, so the table does not show data for this production facility.

You can switch to the location view as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Switch to location view option

../../../../_images/production_filter_location.png

The behavior of the production filters is determined by the following:

  • If a location is selected, then the corresponding production facility is also selected.

  • If all locations which are related to a production facility are unselected, then the corresponding production facility is also unselected.

  • If a production facility is selected/unselected, then the corresponding location is also selected/unselected.

  • If a production/location group is selected/unselected, then the single productions/locations which belong to that group are also selected/unselected.

  • If a single production/location is unselected, then the production/location group which the single production/location belongs to is also unselected.

  • If all single production/locations in a production/location group are selected, then the production/location group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

Warehouse Filters

This side panel contains all the warehouses defined in the input data.

../../../../_images/warehouse_filter.png

Use the checkboxes to filter by Warehouse. Only data of the selected warehouse will be displayed on the page.

../../../../_images/warehouse_filter_2.png

Without unselected filters, so the table shows data for all warehouses.

../../../../_images/warehouse_filter_3.png

When Ankara_LDC is unselected, so the table does not show data for this warehouse.

You can switch to the location view as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Switch to location view option

../../../../_images/warehouse_filter_location.png

The behavior of the warehouse filters is determined by the following:

  • If a location is selected, then the corresponding warehouse is also selected.

  • If all locations which are related to a warehouse are unselected, then the corresponding warehouse is also unselected.

  • If a warehouse is selected/unselected, then the corresponding location is also selected/unselected.

  • If a warehouse/location group is selected/unselected, then the single warehouse/locations which belong to that group are also selected/unselected.

  • If a single warehouse/location is unselected, then the warehouse/location group which the single warehouse/location belongs to is also unselected.

  • If all single warehouses/locations in a warehouse/location group are selected, then the warehouse/location group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

Customer Filters

This side panel contains all the customers defined in the input data.

../../../../_images/customer_filter.png

Use the checkboxes to filter by Customer. Only data of the selected customer will be displayed on the page.

../../../../_images/customer_filter_2.png

Without unselected filters, so the table shows data for all customers.

../../../../_images/customer_filter_3.png

When Aalborg is unselected, so the table does not show data for this customer.

You can switch to the location view as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Switch to location view option

../../../../_images/customer_filter_location.png

The behavior of the customer filters is determined by the following:

  • If a location is selected, then the corresponding customer is also selected.

  • If all locations which are related to a customer are unselected, then the corresponding customer is also unselected.

  • If a customer is selected/unselected, then the corresponding location is also selected/unselected.

  • If a customer/location group is selected/unselected, then the single customers/locations which belong to the group are also selected/unselected.

  • If a single customer/location is unselected, then the customer/location group which the single customer/location belongs to is also unselected.

  • If all single customers/locations in a customer/location group are selected, then the customer/location group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

Transport Filters

This side panel contains all the transport modes defined in the input data.

../../../../_images/transport_filter.png

Use the checkboxes to filter by Transport mode. Only data of the selected transport modes will be displayed on the page.

../../../../_images/transport_filter_2.png

Without unselected filters, so the table shows data for all transport modes.

../../../../_images/transport_filter_3.png

When Inbound RM Truck is unselected, so the table does not show data for this transport mode.

Location From Filters

This side panel contains all the “locations from” defined in the input data.

../../../../_images/locationfrom_filter.png

Use the checkboxes to filter by Location From. Only the data of the selected “locations from” will be displayed on the page.

../../../../_images/locationfrom_filter_2.png

Without unselected filters, so the table shows data for all locatins.

../../../../_images/locationfrom_filter_3.png

When Hamburg_RM is unselected, so the table does not show data for this location.

The behavior of the “locations from” filters is determined by the following:

  • If a location group is selected/unselected, then the single locations which belong to that group are also selected/unselected.

  • If a single location is unselected, the location group which the single location belongs to is also unselected.

  • If all single locations in a location group are selected, then the location group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

Location To Filters

This side panel contains all the “locations to” defined in the input data.

../../../../_images/locationto_filter.png

Use the checkboxes to filter by Locations To. Only the data of the selected “locations to” will be displayed on the page.

../../../../_images/locationto_filter_2.png

Without unselected filters, so the table shows data for all locatins.

../../../../_images/locationto_filter_3.png

When Aalborg is unselected, so the table does not show data for this location.

The behavior of the “locations to” filters is determined by the following:

  • If a location group is selected/unselected, then the single locations which belong to that group are also selected/unselected.

  • If a single location is unselected, then the location group which the single location belongs to is also unselected.

  • If all single locations in a location group are selected, then the location group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

Product Filters

This side panel contains all the products defined in the input data.

../../../../_images/product_filter.png

Use the checkboxes to filter by Product. Only the data of the selected product will be displayed on the page.

../../../../_images/product_filter_2.png

Without unselected filters, so the table shows data for all products.

../../../../_images/product_filter_3.png

When Decorative Paints is unselected, so the table does not show data for this product.

The behavior of the product filters is determined by the following:

  • Only the page related products can be found on the filter side panel.

  • If a product group is selected/unselected, then the single products which belong to that group are also selected/unselected.

  • If a single product is unselected, then the location group which the single product belongs to is also unselected.

  • If all single products in a group are selected, then the product group is also selected.

  • If you click on the Select None option, then all the data on the filter become unselected.

  • If a product is unselected, it will not be displayed on any page.

Period Filters

This side panel contains all the periods defined in the input data.

../../../../_images/period_filter.png

Use the checkboxes to filter by Period. Only the data of the selected period will be displayed on the page.

../../../../_images/period_filter_2.png

Without unselected filters, so the table shows data for all periodes.

../../../../_images/period_filter_3.png

When the 2022 period group is unselected, so the table does not show data for this period group.

The behavior of the period filters is determined by the following:

  • If a period group is selected/unselected, then the single periods which belong to that group are also selected/unselected.

  • If a single period is unselected, the period group which the single period belongs to is also unselected.

  • If all single periods in a group are selected, then the period group is also selected.

  • If you click on the Select None option, then all the data on the filter becomes unselected.

Selected Transport Type Filter

../../../../_images/main_map_transport_type_filter.png

This filter contains all the transportation types, which are the following:

  • Primary (curved, blue): Flows go from Suppliers and represent “the first mile” flows.

  • Secondary (straight, olive): Flows go to Customers and represent “the last mile” flows.

  • InterResource (curved, black): Flows go between Resources (Production facilities, Warehouses, etc.).

  • Direct (straight, olive): Flows go directly from a Supplier to a Customer.

Use the checkboxes to filter by Transportation type. Only the lanes of the selected transportation type will be displayed on the map on Results page.

Resource filter

../../../../_images/main_map_resource_filter.png

This filter contains all of the warehouses and production facilities defined in your input data.

Use the checkboxes to filter by Resources. Only the nodes of the selected warehouses and production facilities will be displayed on the maps on Results page. You can switch to location view as follows:

  1. Click on the settings sign icon at the upper right part of the filter side panel

  2. Click on the Switch to location view option

../../../../_images/main_map_resource_filter_location.png

Attribute filter

This filter is the WebUI table’s own function. It contains all of the attributes defined in your input data.

Click on the arrow next to the attribute, then click on the appearing “Add Filter Rule.”

../../../../_images/attribute_filter_open.png
../../../../_images/attribute_filter_open2.png

Click “Add Filter Rule”

Then a window will pop up where the attributes can be selected with options on whether they should or should not appear.

../../../../_images/attribute_filter_window.png

The attribute filter window

At the first box, you can decide whether the selected attributes should meet conditions such as is, is not, contains, does not contain, or matches regex. If it is “is” or “is not”, then in the second box, a drop-down list will appear from which you can select the attributes; otherwise, you need to fill them in manually.

../../../../_images/attribute_filter_drop-down.png

Second box can be filled from drop-down list.

../../../../_images/attribute_filter_manual.png

Second box can be filled manually.

By clicking on “Apply and Close,” only those attributes will be visible that meet the specified conditions. It will display columns that were originally included in the table at most.

../../../../_images/attribute_filter_isnot_available.png

With condition “is not Available” all columns except Available will be visible.

Following these steps later, further conditions can be added.

../../../../_images/attribute_filter_further_cond.png
../../../../_images/attribute_filter_contains_force.png

With adding condition “contains force” only “Force Open” and “Force Close” columns will be seen.

If the conditions are contradictory, no data will appear. For example, the simultaneous use of “is” and “is not.”

Conditions can be deleted one by one with “-” icons at the end of the rows or by clicking on “Clear All Filters” at the right top corner of the window.

If the table is empty due to the conditions, you can access the window by clicking on the filter icon at the right top corner.

../../../../_images/attribute_filter_empty.png

The table is empty.

The attribute filter operates on the input data only when the data has been saved.