Previous Topic: Use Boolean Operators in a Global Search

Next Topic: Timesheets


Form Subqueries in a Global Search

Subqueries allow you to control the Boolean logic during global searches by grouping clauses with parentheses. For example, to search for documents and forms that contain either "jakarta" or "apache" and "website", include the following sub query in the query:

("jakarta" OR "apache") AND "website"

The preceding query helps ensure that "website" exists and that either term, "jakarta" or "apache", possibly exist.

Escape Special Characters in Global Searches

Escape special characters in global searches properly. To escape these characters, use the "\" (backslash) character before the special character. For example, to escape the special characters in a global search for (1+1):2, use the following query:

\(1\+1\)\:2

The following table lists the special characters:

Special Character

Description

Rule

+

plus sign

\+

-

minus sign

\-

&&

double ampersand

\&&

||

double solid vertical bars

\||

!

exclamation point

\!

(

left parenthesis

\(

)

right parenthesis

\)

{

left curly brace

\{

}

right curly brace

\}

[

left square bracket

\[

]

right square bracket

\]

^

circumflex

\^

"

quotes

\"

~

tilde

\~

*

asterisk

\*

?

question mark

\?

:

colon

\:

\

backslash

\\