Performing an accrue search

Accrue search is a type of search that uses the OR operator logic in a search qualification. During an accrue (OR) search, the Full Text Search engine finds requests that contain any of the specified words in a field, instead of matching an string of characters. The FTS engine matches the pattern of the characters specified in the search.

To perform an accrue search

1. Open a form in which you want to search the records.
2. In a field in the form, enter the double quotation marks followed by the words that you want to search.
3. Enter multiple words separated by a comma.
   The comma acts as the OR accrue operator. The syntax for the search qualification is:

For example, if you wanted to search for the words "firewall" or "blocked," enter:

For this example, a full text search will find requests with any occurrence of the words firewall or blocked with the search for blocked expanded to the word stem block and any of its variants. 

You can use the accrue operator only with fields indexed for FTS. Using the same operator for a field that is not indexed for FTS causes the AR System server to search for the exact entire string in a database search instead of searching for any of the specified search terms, which is called a literal search. For information about literal search, see Performing-a-literal-search.

The following table provides some examples of search results of an accrue search. The table shows a sample qualification and the possible instances that might be available in the database (Example data column). The Matches column highlights only those instances that are displayed as results for that qualification criteria: