Siebel Search Administration Guide > Overview of Siebel Search >
Search Queries Used with Siebel Search
Table 4 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 the 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 the special characters, shown in Table 4 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 4. Search Query Examples
|
|
|
|
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) |
|