Any-field Clauses

Term and phrase clauses can search all fields of the perspective table by eliminating the field name qualifier. The simplest form of an any-field clause is a term clause:

John

This clause searches all fields of the perspective table for a value contains the term John (case-insensitive).

Multiple terms can be provided by separating them by at least one space. For example:

John Smith

This multi-term clause searches for the terms John and Smith in any order and across any field. For example, an object will match if it has a FirstName field that contains John and a LastName field that contains Smith. If all terms are contained in the same field, they can appear in any order and be separated by other terms. For example, an object will match the example above if it has a Name field whose value is “John Smith”, “John Q. Smith”, or “Smith, John”.

An any-field clause can be requested using the field qualifier syntax by using the field name “*”. Example:

*:(John Smith)

This is the same as the unqualified term clause:

John Smith

Phrase clauses can also use the field qualifier syntax and request an any-field search:

*:"John Smith"

This query finds object where the terms John and Smith appear in succession in any field. The phrase can be preceded or followed by other terms.