Bookshelf v7.5.3: Search Operators and Connectives

In addition to AND and OR, and their symbolic equivalents & and |, Siebel Search can accept other operators, which are summarized below in Table 1.

Table 1. Search Operators and Connectives
Operators and Connectives	Effect
AND, and, &	Placed between terms, returns only items containing both terms.
OR, or, \|	Placed between terms, returns items containing either term or both terms.
*	Placed anywhere in a string, returns items containing the string, or containing the string plus any additional characters at the position at which it appears, up to (or beginning with) a space.
?	Placed anywhere in a string, returns items containing the characters specified in the string, such that any character may appear at the location of the question mark.
""	Surrounds a string that, unless modified by a wildcard, must be matched exactly; allows searching for groups of words in their exact order.
()	Orders that the terms and operators surrounded by the parentheses be processed first, regardless of the default processing order.
NEAR, near	Orders that the search for the term preceding or following NEAR be governed by the proximity in characters. This criterion is specified in the Options section of the Siebel Search Contents dialog box, if Siebel Advanced Search is licensed. Note, using NEAR in a query that also contains grouping causes an error.
[]	Used to specify Thesaurus searching options, if Siebel Advanced Search is licensed.
white space character	In a pattern the space separates terms that must appear in a sequence. For example, when you enter "on line" (with quotes), this pattern would match any occurrence of the word ON followed by spaces, tabs, new lines, or any other white space characters in any combination, followed by the word LINE. Quotes are necessary when using white spaces between terms because without them the terms are treated as different words.
-	The hyphen character is treated as an optional punctuation character. The non hyphenated forms include spaces or anything that is interpreted as a punctuation character in Fulcrum.
\	This is an escape character that, when placed immediately before any special pattern character (hyphen, *, backslash, ?, or space) in a pattern, causes the special pattern character to be interpreted literally.

NOTE: The NOT operator used between two query terms can be used to limit the results in a query to records which contain the first term but not the second term. Indices are built with one field mapping to a SUMMARY column, and all other fields or document text mapping to the EXTERNAL_TEXT column in the index. Queries with the NOT operator apply to both the External Text and Summary columns in the search index, and return records which satisfy the search criteria for both the name and summary fields.