OCEAN TERMINAL CONTAINER OPERATIONS N4 OCEAN CARRIER GUIDE Filter Operators A Filter Operator defines the relationship between the Filter Attribute and Value. Used to filter the data in a List View and use a combination of filter Attributes, Operators, and Values. Examples, In Unit View: 1. To search for all Export, create a Filter with Attribute-Category, Filter Operator-is (=), and Value-Export. 2.To search for all units that are not Export units, create a filter with Attribute-Category, Value-Export, but change the Filter Operator-is not (!=). Operator is (=) is not (!=) matches (==) is one of (in) Operator Explanation For alphanumeric Attributes that equals a specific Value. Example: To display all Import units, select the Filter Criteria as Category = Import. For alphanumeric Attributes that do not equal a specific Value. Example: To display all units that are not Imports, select the Filter Criteria as Category != Import. For alphanumeric Attributes that match a specific Value using a Wildcard (*). Example: To display all units with numbers starting with the prefix “MSCU”, select the Filter Criteria as Unit Nbr == MSCU*. For Values or Entities that are numeric and alphanumeric, like Line Operators, when records needed are equal to any one of the Values in a List of Values selected. Multiple Values from a group of possible Values is presented as a list. Example: To display all units that are either Imports or Transships, select the Filter Criteria as Category in [Import, Transship]. *Data results are limited to 1000 Values: If more than 1000 Values needs to be specified, use the OR Group. For example, IN (1000 comma separated values-CSV format) OR IN (1000 comma separated values-CSV format). *To select adjoining and non-adjoining Values in the List View, use the Shift + Ctrl while selecting values. is is before (<) is after (>) is undefined (null) is defined (!null) is less than (<) is greater than (>) is less than or equal (<=) is greater than or equal (>=) YES (is true) NO (is false) For Attributes with date and time Values to show records with an Attribute that is within a selected range using a relative time definition such as Today, Yesterday, or Within one hour. Example: To display all unites that arrived at the facility yesterday, select the Filter Criteria as Time Facility-In is Yesterday. For Attributes with date and time Values that are before the date and time Value provided. Select the date and time Value to search for. *Time defaults to 00:00 if no Time is specified. Example: To display all units that have arrived before the selected date and time, select the Filter Criteria as Time Facility-In < 2021-02-14 12:00. For Attributes with date and time Values to show records with an Attribute that is after the date and time Value selected. Identify the date and time Value needed. Time defaults to 00:00 if not Time is defined. Example: To display all units that have arrived at the facility after the selected date and time, select the Filter Criteria as Time Facility-In > 2021-02-14 12:00 and all of the units that have arrived after the selected date and time will be shown. For Attributes with alphanumeric, date and time, long, or double Values when records are needed with an Attribute that does not have a specific Value selected. Example: To display all units that have not arrived (do not have a Facility-In Time), select the Filter Criteria as Time Facility-In null and all units that do not have a facility-in time defined will be shown. For Attributes with alphanumeric, date and time, long, or double Values when records are needed with an Attribute that has a Value selected. Example: To display all units that have arrived (have a Facility In-Time), select the Filter Criteria as Time Facility-In !null and all units that have a facility-in time defined will be shown. For Attributes with numeric Values to show records with an Attribute that is less than a specified value. Example: To display all units with a gross weight less than 8,000 lbs, select the Filter Criteria as Gross Weight (lb) < 8000 lb. For Attributes with numeric Values to show records with an Attribute that is greater than a specified value. Example: To display all units with a gross weight greater than 8,000 lbs, select the Filter Criteria as Gross Weight (lb) > 8000 lb. For Attributes with numeric Values to show records with an Attribute that is less than or equal to a specified value. Example: To display all units with a gross weight less than or equal to 8,000 lbs, select the Filter Criteria as Gross Weight (lb) <= 8000 lb. *To see Attributes with date Values (without time) to show records with an Attribute that is before or on the date Value specified. For Attributes with numeric Values to show records with an Attribute that is greater than or equal to a specified value. Example: To display all units with a gross weight greater than or equal to 8,000 lbs, select the Filter Criteria as Gross Weight (lb) >= 8000 lb. *To see Attributes with date Values (without time) to show records with an Attribute that is after or on the date Value specified. For Attributes that can be either true or false for an Entity to show records with an Attribute that is true for an Entity. Example: To display all units that have Hazards associated, select the Filter Criteria as Hazardous? is true. For Attributes that can be either true or false for an Entity to show records with an Attribute that is false for an Entity. Example: To display all units that do not have Hazards associated, select the Filter Criteria as HAZARDOUS? Is false. Version 1.0 – February 16, 2021 12/70
