Search operators will differ depending on the data type of a property. You can use the following search operators in the Advanced Inquiry window to refine your search criteria:
| Data Type | Text | Symbol | Description |
|---|---|---|---|
| String | At least one value | | | Contains at least one of the words you type in. Separate multiple values with a semi-colon. |
| All values | & | Contains ALL the search terms you type in. Separate multiple values with a semi-colon. | |
| No Value Exists | Ø | Contains properties with a null value; an empty set of results. No input required. | |
| Date | Exactly | = | Contains the exact phrase you type in.
Example: =04/15/2015 will return all matches with a date of April 15, 2015. |
| Greater than | > | Search for matches after a certain period
of time.
Example: >04/15/2015 will return all matches with dates after April 15, 2015. |
|
| Less than | < | Search for matches before a certain period
of time.
Example: <04/15/2015 will return all matches with dates before April 15, 2015. |
|
| Range of values | : | Contains dates within a certain range. Separate
range values with a colon.
Example: 04/01/2015:04/30/2015 will return all values with a date between April 1st and 30th, 2015. |
|
| No Value Exists | Ø | Contains properties with a null value; an empty set of results. No input required. | |
| Numeric | At least one value | | | Contains at least one of the numbers you type
in. Separate multiple values using semi-colons.
Example: 99999; 88888 will return all values containing either 99999 OR 88888. |
| All values | & | Contains ALL the numbers you type in. Separate
multiple values using semi-colons.
Example: 99999; 88888 will return all values containing both 99999 AND 88888. |
|
| Greater than | > | Search for values greater than the number entered. | |
| Less than | < | Search for values less than the number entered. | |
| Range of values | : | Searches for numbers within a certain range.
Separate range values with a colon.
;Example, 100:1000 will return all values between 100 and 1000. |
|
| No Value Exists | Ø | Contains properties with a null value; an empty set of results. No input required. | |
| True/False | Exactly | = | Contain the exact phrase you type in. |
| No Value Exists | Ø | Contains properties with a null value; an empty set of results. No input required. |