Operators
Searching in Compass requires Operators. Operators differ based on the field type.
For example, the following operators are available for the date fields (i.e., Initiation Date):
-
- = | “Equals to”: limits the results to records where the data in this field matches the criteria you enter
- >=, <=, >, < | “Greater than/Equal to”, “Less than/Equal to”, “Less Than”, and “Greater Than” are used primarily to search for results based on a specific number, date, or a date range. For example, dates, zip codes, badge numbers, etc. These operators are available on most numeric fields.
- The “greater than” and “less than” operators are not available on fields that contain data in the form of a picklist or a free text field, such as the Member Status Reason field. The following operators are available for fields such as these:
- =
- Not - Use "Not" to return results where the data in the field is NOT equal to the criteria entered/selected.
- Null - Use "Null" to return all records where NO data exists in the field.
- Not Null - Use "Not Null" to return all records that HAVE data in the field.