Siebel Search Administration Guide > The User Experience >

Search Queries


Table 2 shows a number of examples of queries using these operators and the results they return. Note that search operators are conventionally displayed in uppercase; however, query strings are not case-sensitive, and your operators need not be in uppercase. Also note that the result may be affected by the operator you selected in the Separate Terms With drop-down list in the Siebel Search options property sheet. This setting determines which operator is assumed when no Boolean operator appears in the query.

NOTE:  When these special characters are used, advanced features like synonym searching and approximate searching will not be applied to searches.

For instructions on administering these settings, see Administration of Siebel Search.

Table 2. Search Query Examples
Operator
Query Type
Query Example
Separate Terms With
Returns All Records and Documents That:
AND
AND query
performance AND memory
N/A
Contain both performance and memory
&
AND query
performance & memory
N/A
Contain both performance and memory
OR
OR query
performance OR memory
N/A
Contain either performance or memory
|
OR query
performance | memory
N/A
Contain either performance or memory
""
Phrase query
"memory performance"
N/A
Contain the entire phrase, memory performance
 
 
memory performance
AND
Contain both performance and memory
 
 
memory performance
OR
Contain either performance or memory
"" ""
Multiple phrases
"Microsoft Windows" "Sun Solaris"
AND
Contain both Microsoft Windows and Sun Solaris
"" ""
Multiple phrases
"Microsoft Windows" "Sun Solaris"
OR
Contain either Microsoft Windows or Sun Solaris
?
Wildcard
operate?
N/A
Contain operates or operated, but not operate
?
Wildcard
?rag
N/A
Contain brag, crag, drag, or frag
*
Wildcard
*rang*
N/A
Contain any of arrange, arranged, arranges, arranging, orange, orangutan, range, ranges, ranging, rang, sprang, strange, stranger, strangest, strangle, wrangle, and so on.
( )
Grouping
(word OR excel) AND NOT microsoft
N/A
Contain either word or excel but do not contain microsoft
( )
Grouping
(word OR excel) NOT microsoft
N/A
(Error)
( )
Grouping
word OR (excel AND NOT microsoft)
N/A
Either contain word, or contain excel and have no reference to microsoft (microsoft may appear in the same document as word, but not in the same document as excel)
 
Multiple search terms
word OR excel NOT microsoft
N/A
Contain anything (finds all records and documents)
 
Multiple search terms
word OR excel AND NOT microsoft
N/A
Contain either word or excel but do not contain microsoft
NEAR
Proximity
log* NEAR performance
N/A
Contain any form of the word log within n characters of performance, where n is the number set in the Near Means field of the Options area of the Siebel Search Contents dialog box (Advanced Search only)


 Siebel Search Administration Guide, Version 7.5, Rev A 
 Published: 18 April 2003