Term Clauses

A term clause searches a specific field for one or more terms. To designate it as a contains clause, the field name must be followed by a colon. Example:

Name:Smith

This clause searches perspective objects’ Name field for the term Smith (case-insensitive). To specify multiple terms, enclose them in parentheses. Example:

Name:(John Smith)

To match this clause, an object’s Name field must contain both John and Smith, but they can appear in any order and be separated by other terms.

Be sure to enclose multi-term clauses in parentheses! The following query looks like it searches for John and Smith in the Name field:

Name:John Smith // doesn’t do what you think!

But, this sequence is actually interpreted as two clauses that are AND-ed together:

Name:John AND *:Smith

Matching objects must have John in the Name field and Smith in any field. In OLAP applications, this query isn’t allowed because the second “all fields” clause type is not supported.