Search variables

You can use the variables below to narrow or broaden the search criteria.

Variable	Function	Description
%	Wildcard	This variable performs a wildcard search and retrieves all the files in that project. It can be used for both alpha and numerical field values. When placed at the beginning of the search criteria, the index field is searched for the entered criteria within the index field, and not just at the beginning.
~	Exact	This variable performs an exact search, when you place it at the end of the search string. It can be used for both alpha and numerical values. For example Brian~ retrieves all the records having the exact value Brian. Search for Blank Index Fields: To search for the files in a project that have blank fields, you can perform a tilde (~) search. Type a tilde (~) into the index field that you think might have blank fields. The search result will show all the files that did not have a value stored for that index field. Note: You can use this feature only for the index fields that have been configured as Text, Number, or Terminal Digit field type.
!	Exclude	This variable excludes the search string from the search result, when you place it in the beginning. For example !Brian retrieves all the files that do not begin with Brian. Search for Index Field containing any value: To perform this search, enter an exclamation mark (!) and a tilde (~) into the index field to be searched. The displayed search results will show all of the files that contained some value for the index field. Any file that does not have value stored for that index field will not be displayed.
|	Or	This variable performs an alternate search for a given criteria. For example, if you search for a string John | Brian, then the search result displays all records with either John or Brian.