Search criteria list
The search for documents can be enhanced by using expressions for comparison with the property you select in the Search dialog. The following is a list of valid expressions for defining search criteria.
-
A search for special characters requires the special character to be enclosed by brackets [ ]. Examples: [*], [“], [ [ ], [ ] ], [?]
-
A search involving dates requires that the date be enclosed by the pound character #. Example: #MM/DD/YYYY#
| Expression | Definition and Examples |
|---|---|
| > | Greater than “> 123” will return values greater than 123. |
| < | Less than “< 123” will return values less than 123. |
| >= | Greater than or equal to “>=123” will return values greater than or equal to 123. |
| <= | Less than or equal to “<=” will return values less than or equal to 123. |
| = | Equal to “=123” will return values equal to 123. |
| != | Not equal to “!=123” will return values not equal to 123. |
| * | Wildcard “A*” will return words starting with A. Extended search options are only available with managed searches. |
| ? | Single character wildcard “ABC?” returns all words that start with ABC and contain one additional character. |
| - | Through [A-F]BCD returns all four letter words that start with the letters A through F. |
| ^ | Not [^A]BCD returns all four letter words to do not begin with A. |
| AND | And “Iron*” and “Steel*” displays results where both words are found. |
| OR | Or “Red” or “Black” displays results where either word is found. |
| Between x and y | Between Between #MM/DD/YYYY# and #MM/DD/YYYY# will return values between the two dates (based on regional format). The value used for y should be greater than the value used for x, else an error will result or no results will be found. |
| IsEmpty | Is Empty Displays results where the field does not have a value (blank or NULL). |
| IsNotEmpty | Is Not Empty Displays results where the field has any value other than blank or NULL. |
© 2021 UDS