Specifying filter criteria - HxGN EAM - Version 12.0 - Help

HxGN EAM Barcoding

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
12

You can specify filter criteria on the Batch Printing form.

  1. Select a field on which to filter from the first drop-down list.

  2. Select an operator from the second drop-down list. See the following table for operator options:

    Operator

    Definition

    Equals

    Search for items with a value equal to the entered value.

    Greater Than

    Search for items with a value greater than the entered value.

    Less Than

    Search for items with a value less than the entered value.

    Greater Than or Equals

    Search for items with a value greater than or equal to the entered value.

    Less Than or Equals

    Search for items with a value less than or equal to the entered value.

    Contains

    Search for items with a description that contains the value.

    Does Not Contain

    Search for items with a description that does not contain the entered value.

    Starts With

    Search for items with a description that begins with the value.

    Ends With

    Search for items with a description that ends with the value.

    Is Empty

    Search for items with a description that has no entered value.

    Not Empty

    Search for items with a description that has any entered value.

    Does Not Equal

    Search for items with a description that does not equal the entered value.

    Selected

    Search for items where the check box is selected. This applies to check box fields only.

    Not Selected

    Search for items where the check box is not selected. This applies to check box fields only.

  3. Enter a value for which to filter in the third field.

    Enter relative dates by specifying + or – with units in days. For example, "-1" is one day back, and last week would be >="-7".

  4. Click AND/OR to select one of the following join operators:

    Option

    Description

    AND

    Select to include records that include all joined conditions.

    OR

    Select to include records that contain one or the other condition.

  5. Click (or) to add a parenthesis to the highlighted row. These parentheses are used when running a query to group statements together when mixing AND and OR statements.

  6. Specify additional conditions by which to filter as necessary.

    Click Add Line to add additional lines to the filter.