Advanced Filtering

For more complex filtering, click the Advanced button on the Filter Table dialog.

As before, click Match All to include only candidates that match all of the filtering criteria, or click Match Any to include candidates that match any of the filtering criteria. Then add search operators and new search fields as desired.

Adding Search Operators

Select one of the following operators for each data column you want to filter:

  • Starts with: Includes only items starting with the entry

  • Ends with: Includes only items ending with the entry

  • Equals: Includes only items that are identical to the entry

  • Does not equal: Includes only items that are not exactly identical to the entry

  • Less than: Includes only items that are less than the entry

  • Less than or equal to: Includes only items that are less than or equal to the entry

  • Greater than: Includes only items that are greater than the entry

  • Greater than or equal to: Includes only items that are greater than or equal to the entry

  • Between: Includes only items that are between the entries

  • Not between: Includes only items that are not between the entries

  • Contains: Includes only items containing the entry

  • Does not contain: Includes only items that do not contain the entry

  • Is blank: Includes only items that are blank

  • Is not blank: Includes only items that are not blank

Enter filtering criteria in the data fields.

Click Apply to update the data table with the selected operators and filtering criteria.

Click OK to close the dialog.

Other options:

Click Reset to set the filters back to their original values.

Click Save to save the filter settings.

Click Add Fields to add search fields.

Click Reorder to re-prioritize search fields.

Retrieve and apply a saved search from the list of saved searches.

Click Basic to toggle to basic search mode.

Adding Search Fields

Click Add Fields to add search fields.

Select from the list of fields that are currently in the data table but not in the Filter Table dialog.

Enter filtering criteria in the new data fields.

Click Apply to update the data table with the new data fields.

Click OK to close the dialog.

Other options:

Click Reset to set the filters back to their original values.

Click Save to save the filter settings.

Click Reorder to re-prioritize search fields.

Retrieve and apply a saved search from the list of saved searches.

Click Basic to toggle to basic search mode.