Join us October 22nd to hear Coglate-Palmolive, IDC, and Sequoia Capital discuss moving to a digital-first environment
Learn more

Last updated

November 18, 2021

Table of contents

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., *, ?).

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:

Originator:Bella Vendor:Tribeca

To search for only those files where Bella is the originator OR Vendor is Tribeca, enter:

Originator:Bella or Vendor:Tribeca

To search for files where Bella is the originator and Tribeca is not the vendor, include a minus symbol:

Originator:Bella -Vendor:Tribeca

For fields (column names) that contain a space, such as Part Number, enclose the text in backticks::

`Part Number`:12345-A

Similarly, if the value you’re searching for contains spaces you should enclose the value in backticks:

`Part Number`:`12350 ABC`Originator: `Bella Donna`

NOTE: Make sure you're using backticks, not single quote characters.


To set lower and upper bounds in a query, you can also use range operators, such as greater than (>) and less than (<).

The syntax is as follows:

Greater than Date:>2020-10-05
Less than Date:<2020-10-31
Range Date:>2020-10-05 Date:<2020-10-25

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.

motherboard Quantity:<10 date:="">2020-03-23</10>


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:


Stay in the loop

Get our Release Notes hot off the press, straight into your inbox.

Need more help?

Talk to someone