Performing an accrue search

During an accrue (OR) search, the FTS engine finds requests that contain any of the specified words in a field, instead of matching a string of characters. The FTS engine matches the pattern of the characters specified in the search. To perform an accrue search, use double quotation marks around the words to search for, separating the words with a comma. The comma is the accrue operator. The syntax for the search qualification is:

<field> LIKE "<word1>,<word2> . . . <wordN>"

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

<field> LIKE "firewall,blocked"

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 with any of its variants.

Note

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 literal string with a database search.

The following table shows the expected search result using an accrue search.

Results of searches that use an accrue search

Qualification

Example data

Matches

<field> LIKE "firewall,blocking"

firewall blocks access

firewall will block access

firewall blocking my access

firewall blocked her access

firewall did not block access

have the firewall block access

firewall is not working

try blocking his access

<field> LIKE "firewall,blocked%"