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.

Operators

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.

Image credits: Apple and Keychron

Range

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.

Wildcards

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:

© 2022 Impira Inc. All rights reserved. This site is built with Motif.