Criteria Operator Glossary
When creating a search criteria statement (see Searching in i-Sight: Create Search Criteria Statements), the operator options will dynamically adjust based on the record field type by which you have chosen to search. The chart below lists all operator options available for each standard record field type. There may be additional fields that are custom for your application which are covered in this article.
| Record Field Type |
Description of Record Field |
Criteria Operators |
|---|---|---|
| Case |
Case number. The search will only return case numbers that you can access. |
Is Is Empty |
| Color | Display a color input. | N/A |
| Date | Calendar date. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| Datetime | Both a date and time value. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| Delay | Defines time in a number in hours and minutes. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| Dependent Picklist | A dropdown list where only one value can be selected. | Is Is Empty Is Not Is Not Empty |
| An email address, either linked to an existing i-Sight user or manually typed (ad hoc). | Is Is Empty Is Not Is Not Empty |
|
| Email Multiple | One or more email addresses, either linked to an existing i-Sight user or manually typed (ad hoc). | Is Empty Is Not Empty |
| Entity | A dropdown list of data from other entities for the corresponding case. Values are based on the logic defined. | N/A |
| Integer | A numeric value with no decimal. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| Money | A money amount. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| Number | A numeric value with a decimal point. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| Number Range Picklist | A range of numbers presented as a dropdown list of the whole numbers in the range. | Is Is Empty Is Not Is Not Empty |
| Party | A party record’s first and last name for the corresponding case. | Is Is Empty Is Not Is Not Empty |
| Phone Number | A text field with validation to ensure proper phone number formatting. | Is Is Empty Is Not Is Not Empty |
| Phone Number Multiple | One or more phone numbers. | Is Empty Is Not Empty |
| Picklist | A dropdown list of set values where only one value can be selected. | Is Is Empty Is Not Is Not Empty |
| Picklist Multiple | A dropdown list of set values where more than one value can be selected. | Is Empty Is Not Empty |
| Postal Code | A text field with validation to ensure postal code formatting. | Is Is Empty Is Not Is Not Empty |
| Radio | A list of options where only one can be selected. | Is Is Empty Is Not Is Not Empty |
| Secret | A text field that uses password input to hide the value. The value appears when hovered over or focused on. | N/A |
| Team Multiple | One or more teams. | Is Empty Is Not Empty |
| Text Area | A large text field for narratives or summaries. | N/A |
| Text Box | A small text field for names, or one to four-word answers. | Is Is Empty |
| Text Box Multiple | Multiple untranslated text values. | N/A |
| Time | A time value. | Between Greater Than Greater Than or Equals Is Is Empty Is Not Is Not Empty Less Than Less Than or Equals |
| URL | A text field containing a link. | Is |
| User | An existing i-Sight user. | Is Is Empty Is Not Is Not Empty |
| User Multiple | One or many i-Sight users. | Is Empty Is Not Empty |