Specifying Dataspy filter criteria - HxGN EAM - 12.0 - Help

Select the fields, conditions, and values upon which to filter a list of records.

1. On any list view page, select the Dataspy to edit from the drop-down list on the filter bar, and then click Edit.

2. Click Filter from the left-hand column of the Dataspy editor.

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

4. Select an operator from the second drop-down list.

   See the following table for operator options:

   Operator	Definition
   Starts With	Search for items with a description that begins with the entered value
   Equals	Search for items with a value equal to the entered value.
   Does Not Equal	Search for items with a description that does not equal the entered value.
   Contains	Search for items with a description that contains the entered value.
   Does Not Contain	Search for items with a description that does not contain the entered value.
   Ends With	Search for items with a description that ends with the entered value.
   Is Empty	Search for items with a description that has no entered value.
   Is Not Empty	Search for items with a description that has any entered value.
   Less Than	Search for items with a value less than the entered value.
   Greater Than	Search for items with a value greater than the entered value.
   Less Than or Equals	Search for items with a value less than or equal to the entered value.
   Greater Than or Equals	Search for items with a value greater than or equal to the entered value.
   Selected	Search for items where the check box is selected. This applies to checkbox fields only.
   Not Selected	Search for items where the check box is not selected. This applies to check box fields only.

5. 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".

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

   • Include records that include all joined conditions - Select AND.

   • Include records that contain one or the other condition - Select OR.

7. 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.

8. Enter additional conditions by which to filter as necessary.

   Click Add Line to add additional lines to the filter.

   To remove a filter line, choose the blank selection from the first drop-down list.