Search Operators

Search operators are the choices used in the Contains list when creating or modifying a Search. Use them to modify search results, such as to look for what is not available (for example, all invoices which are not marked “paid”) or to restrict results (such as only bills over thirty days and over $100).

If you have a Field with a Character data type with no Field List associated, you’re most likely to be using a Contains condition, as these Fields are frequently difficult to match. For example, a first name might be entered as “Elizabeth,” “Beth,” or “Lizzie.” An address might be “Church Street” or “Church St.”

While you can assign Contains search conditions on Numeric or Decimal, using Equals or Greater Than/Less Than operators might yield more useful results.

Operator	Use in a Search Field	Field Data Type	Notes
Contains	To find results which at least partially match the query	Character, Numeric, or Decimal (their default)	Use to search for a known part of a value, such as one word in a phrase, without having to provide the entire value. Example: If you type in “Square 9” the Contains Search will find both “Square 9” and “Square 9 Softworks."
Equals	To find results which exactly match the search value to create precise searches	Any data type	Useful for finding specific names, numbers, or date/time ranges. Use with a wildcard asterisk ( * ) to create a “begins with,” “ends with,” or “contains” search.
Does Not Equal	To find results whose value is everything except the search value	Any data type	Use for the opposite effect of Equals. Often combined with other criteria to narrow the “everything else” returned by the Does Not Equal operator.
Greater than or Equal to	To find numeric results which return a value greater than or equal to the search value	Numeric, Date/Time, or Decimal
Less than or Equal to	To find numeric results which return a value less than or equal to the search value	Numeric, Date/Time, or Decimal
Is not Empty	To find the presence of any data in the Field, rather than specific results	Any data type
Is Empty	To find the lack of data in the Field, rather than specific results	Any data type	Often used to begin a process. Example: If the Approval Status is empty, then the invoice hasn’t begun the approval process.