Specifying Dataspy filter criteria
Select the fields, conditions, and values upon which to filter a list of records.
- On any list view page, select the Dataspy to edit from the drop-down list on the filter bar, and then click Edit.
- Click Filter from the left-hand column of the Dataspy editor.
- Select a field on which to filter from the first drop-down list.
-
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 check box fields only. Not Selected Search for items where the check box is not selected. This applies to check box fields only. -
Enter a value for which to filter in the third field.
Note: Enter relative dates by specifying + or – with units in days. For example,"-1" is one day back, and last week would be >="-7".
-
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.
-
- 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.
-
Enter additional conditions by which to filter as necessary.
Note: 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.
Parent topic: Specifying Dataspy criteria
Related topics