How to search with operators and wildcards
Impira enables you to run advanced search queries via operators (e.g., and, or) and wildcards (e.g., *, ?).
Example: Return Merchandise Authorization forms
Imagine that you have a Collection with a number of Return Merchandise Authorization forms. On these forms, you’ve extracted some fields like Originator, Vendor, Part Number, Quantity, and Date.
To search for only those files for which Bella was the originator, enter:
To search for only those files where Bella is the originator and the Vendor is Tribeca, enter:
To search for only those files where Bella is the originator OR Vendor is Tribeca, enter:
To search for files where Bella is the originator and Tribeca is not the vendor, include a minus symbol:
For fields (column names) that contain a space, such as Part Number, enclose the text in backticks:
Similarly, if the value you’re searching for contains spaces you should enclose the value in backticks as well:
Tip: Backticks — the apostrophe lookalike
Backticks look a lot like apostrophes (ʼ) or single quotation marks (‘), so make sure you pick the right symbol on your keyboard as you write IQL queries.
To set lower and upper bounds in a query, you can also use range operators, such as
> (greater than) or
< (less than).
The syntax is as follows:
The following query free-text searches for “motherboard” in files where the Quantity field is less than 10 and the Date is greater than (i.e., comes after) March 23rd, 2020.
You can also use wildcards in your searches to match fields where the term given in the query is part of a longer string.
Impira supports the following wildcards:
- Asterisk (*): Matches any character sequence (including the empty one)
- Question mark (?): Matches any single character
For example, the query below matches any filename that ends with .jpg:
The following query would return matching search results for files containing text such as Apple, Addle, or Ankle: