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