Search operators

You can use search operators when performing a search. A search operator is a sign or a word that expands your search options. You should write the search operators with your search criteria.

Tip: For Date and DateTime fields, you can enter values such as +1d or -1w to adjust the date fields by the number of years, quarters, months, weeks, days, hours, minutes or even seconds. See Shortcut keys for more information.

Note: Searches work differently in text fields and in free text fields.

Search using text fields

Not all search operators can be used across all search pages and fields. See how you can use the search operators below.

Operator	Name	Description
*	Wildcard (asterisk)	Replaces one or more characters. Example Search in the field Title on the search page for cases. If you write: Sun* - you will find cases where the field Title begins with sun, for example sun vehicle. sun - you will find cases where the field Title contains sun, for example a sunder, evening sun, and sun vehicle. sun - you will find cases where the field Title* ends with sun, for example evening sun.
^	Hat (Circumflex)	Removes the distinction between uppercase and lowercase letters. Example If you write ^sun in the field Title, you will find cases where the field Title contains the word sun, regardless of whether it is in uppercase or lowercase letters, for example Chocolate SUNdays Ltd.
\|	Or	Searches for individual elements where one or more of the entered words appear. Example By writing market\|currency in the free text search field, you will find all documents where at least one of the words market or currency occurs.
&	And	Searches for individual elements where all the entered words appear. To search for the character `&`, not as an operator, but, for example, as part of the name of a contact, you must insert a backslash before the character, that is, `\&`. Example To find Liebestraum, Immergut & Co, you should search by typing Liebestraum, Immergut \& Co.

Search using free text fields

Not all operators can be used on all search pages and fields. See how you can use the search operators below.

Operator	Name	Description
*	Wildcard (asterisk)	Replaces one or more characters. Example If you search for cases and enter: Sun* - you will find cases that contain words that begin with sun, for example sun vehicle. sun - you will find cases that contain the word sun, for example a sunder, evening sun, and sun vehicle. sun - you will find cases that contain words that end with sun, for example evening sun. Wildcard searches will vary, depending on whether you have selected Normal search* or Extended search. Normal search: The wildcard () at the beginning of the search term will be ignored. Wildcard characters in the middle or at the end of the search term will be processed. This is the default search setting. Extended search: All wildcards in the search term will be processed. Using searches, for example sun and sun is not recommended for free text searches as all WorkZone elements are traversed for all full and partial occurrences of the search term. This type of search can produce a large number of results, consume noticeable system resources and take significantly longer to display the search results.
?	Question mark	Replaces exactly one character. Example If you write Pe?ersen and click Contacts in the menu, you will find all contacts with the name Petersen or Pedersen, but not Pettersen.
\|, OR	Or	Searches for individual elements where one or more of the entered words appear. For free text searches for documents, the search is performed in the meta data fields and in the document itself. Example By writing market\|currency in the free text search field, you will find all documents where at least one of the words market or currency occurs.
&, AND	And	Searches for individual elements where all the entered words appear. Example To find all documents where all the words market AND currency occur (for example, the words can be found in the meta data fields of the document or as indexed free text), you need to enter market AND currency in the free text search field on the document detail page. To search for the character & not as an operator, but, for example, as part of the name of a contact, you must insert a backslash before the character, that is, \&. Example To find Liebestraum, Immergut & Co, you should search by typing Liebestraum, Immergut \& Co.
~, NOT	Not	Searches for items where the words you enter after the operator do not occur. Example Find all documents where none of the words after NOT occur. If you write interest NOT deposits, you will find all the documents in which the word interest but not deposits is found. You should always search for an item that contains "<word_to_find> NOT <word_to_find_not>". Searching for NOT deposits will produce no result.
+	Fuzzy search	Utilizes Oracle Fuzzy Matching to search for similarly spelled words that only diverge marginally from the searched terms. The level of sensitivity to divergence can be defined in your Oracle database to enable more or less results. Example The search criteria "+petersen" will find contact names similar to "petersen" such as peddersen, pedersen, and petersen. The default parameters of Oracle's Fuzzy Matching (similarity score lower limit and maximum number of expanded terms) can be changed by a system or database administrator in your Oracle database to increase or decrease the number of search results. This change must be made at index time. See Also Fuzzy Matching and Stemming (external link to Oracle documentation site) Oracle Text Indexing Elements (external link to Oracle documentation site)