Search variables

You can use variables to narrow or broaden the search criteria. You can manually enter these variable or let FileBound add them automatically with the use of the Search String Builder.

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.
_ Wildcard This variable represents a single character. For example, h_t retrieves hot, hat, or hit.

[ ]

Wildcard This variable represents any single character within the brackets. For example, h[oa]t retrieves hot and hat, but not hit.
^ Wildcard This variable represents any character not in the brackets. For example, h[^oa]t retrieves hit, but not hot and hat.
- Wildcard This variable represents a range of characters within the brackets. For example, c[a-b] retrievescat and cbt.
~ 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.

You can perform exact searches only for index fields that have been configured as Text field type.

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.
! 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, John | Brian retrieves all records with either John or Brian.