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. 

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%"

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


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*