Filter Operators (List Views)

The operator in a filter is like the verb in a sentence. Operators specify how filter criteria relate to one another. Refer to this list of filter operators when setting filters on List ViewClosed One of the three user Interfaces in ATS v2 (the others being Kanban View and Table View)s. This article shows you how operators work and how to use them.

Filter Operators

Below are some common operator symbols and their use cases for filtering and searching data.

Operator

 Symbol Use Case

Example to Display

Equals

 LIKE 'value%' Exact match

Only AccountsClosed A business entity/company from the city Chicago.

Not Equal to

 != Excludes matches

All Accounts except of the ones that are from the city Chicago.

Less than

< Values less than entered

Only Accounts with Annual Revenue below 100.000USD.

Greater than

 > Values greater than entered

Only Accounts with Annual Revenue from 100.000USD.

Less or equal

 <= Values less than or equal to entered

Only Accounts with Annual Revenue less or equal 100.000USD.

Greater or equal

 >= Values greater than or equal to entered

Only Accounts with Annual Revenue greater or equal 100.000USD.

Contains

LIKE '%value%' Field includes search string

If Account contains "Chicago” results would find Chicago Travel, Chicago Pro Shop, and Tour Chicago.

Does not contain

NOT LIKE '%value%' Field excludes search string

Mailing Address Line 2 does not contain P. O. Box.

Starts with

 LIKE 'value%' Matches starting characters

If you enter “Account starts with Chicago,” you find Chicago Travel and Chicago Pro Shop, but not Tour Chicago.

Multiple Filters

You can use multiple filter options when setting filters on List Views to:

  • Add more than one filter
  • Add Filter Logic
  • Different Operators

 

If you want a specific range of Accounts or ContactsClosed A contact (or client contact) is the person who the recruiter is working with at a Company. In Talent Rover a Contact can be either a Client Contact or a Candidate Contact. Both types of Contacts are stored in the same object (Contact)., you can add multiple filters to your List Views. For example, if you want to see only your Illinois prospect Accounts you would follow these steps:

  1. Navigate to the desired Object tab (EX: Accounts tab).
  2. Once you select an Object (EX: Referrals), a list of Recently Viewed records displays.
  3. Select the tab's drop-down on the left and then click your desired List View, for example Recently Viewed.
  4. Select the Filter icon and choose Filter by Owner.
  5. Select My Accounts radio button.
  6. Click Done.
  7. Click Add Filter.
  8. Click the Field drop-down and select the field you'd like to filter by (EX: State/Province.)
  9. Click the Operator drop-down and choose what operation you'd like the filter to implement (EX: =).
  10. Enter a value you'd like to filter by (EX:“Hawaii”).
  11. Click Done.

  12. Click Add Filter.
  13. Click the Field drop-down and select the field you'd like to filter by (EX: Type).
  14. Click the Operator drop-down and choose what operation you'd like the filter to implement (EX: >)..
  15. Enter a value you'd like to filter by (EX: "Prospect").
  16. Click Done.
  17. To delete the filter, click X.
  18. To retain your changes, click Save.