Field filter operators

This topic describes operators that you may apply in a field filter. The available operators depend on whether a field is a text, date, or numeric field.

Is equal to

Looks for records that have exactly the value you specify. This can be a numeric value or a text value. For example, you can search for records with a MatchScore value of exactly 82, or records with a LastName value of "Smith."

Is not equal to

Looks for records that have any value other than the one you specify. This can be a numeric value or a text value. For example, you can search for records with any MatchScore value except 100, or records with any LastName except "Smith."

Starts with

Looks for records that start with a particular value in the selected field. For example, if you filter for "Van" in the LastName field you would see records with "Van Buren", Vandenburg", or "Van Dyck".

Contains

Looks for records that contain the value you specify in any position within the selected field. For example, if you filter for "South" in the AddressLine1 field, you would see records with "12 South Ave.", "9889 Southport St.", "600 South Shore Dr.", and "4089 5th St. South".

Does not contain

Looks for records that do not contain the value you specify in any position within the selected field. For example, if you filter for "South" in the AddressLine1 field, you would not see records with "12 South Ave.", "9889 Southport St.", "600 South Shore Dr.", and "4089 5th St. South".

Ends with

Looks for records that end with a particular value in the selected field. For example, if you filter for records that end with "burg" in the City field, you would see records with "Gettysburg", "Fredricksburg", and "Blacksburg".

Is greater than

Looks for records that have a numeric value that is greater than the value you specify.

Is greater than or equal to

Looks for records that have a numeric value that is greater than or equal to the value you specify. For example, if you specify 50, you would see records with a value of 50 or greater in the selected field.

Is less than

Looks for records that have a numeric value that is less than the value you specify.

Is less than or equal to

Looks for records that have a numeric value that is less than or equal to the value you specify. For example, if you specify 50, you would see records with a value of 50 or less in the selected field.

is after

Looks for records that have a date or time value that is later than the value you specify.

Is after or equal to than

Looks for records that have a date or time value that is equal to or later than the value you specify.

Is before

Looks for records that have a date or time value that is earlier than the value you specify.

Is before or equal to than

Looks for records that have a date or time value that is equal to or earlier than the value you specify.