Table 2. 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) |