Search Criteria List
The search for documents can be enhanced by using expressions for comparison with the property you select in the Property portion of the Search dialog. The following is a list of valid expressions for defining search criteria.
-
Searching 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#
-
A text search using the expression for not equal to should include a space between the = and the search string which should be enclosed in quotes. Example: != “cat”
-
The property Document Number is of type string and not numeric, therefore a search based on numeric value may not return the results you expect.
| 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 “<=123” will return values less than or equal to 123. |
| = | Equal to “=123” will return values equal to 123. |
| ? | Single character wildcard “ABC?” returns all words that start with ABC and contain one additional character. |
| 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. |
| True | True Displays result where the value is True. Checked Out set to True displays documents that have a status of Checked Out. |
| False | False Displays result where the value is not true. Checked Out set to False displays documents that are not checked out. |
© 2021 UDS