Limitations of FTS
Limits to performing a full text search include:
- In accrue searches, you cannot search for most punctuation marks because they are treated as word separators.
- In accrue searches, do not use words from the Ignore Words List. For example, if the word the is in the Ignore Words List, searching on the phrase
the, database, requestin the Short Description field might return requests with the word the in them, but it is not used in the search itself. For additional information about the Ignore Words List, see Configuring the Ignore Words List.
- Submitted or modified requests might not appear immediately in the results list if you are searching on a field enabled for FTS. Sometimes a short delay occurs between the time the request is submitted or modified in the database and the time that the request is available for searching in the FTS index.
- The indexing of fields on form types that require scanning for changes (join, vendor, and view forms with data updated outside of BMC Remedy AR System) does not recognize the deletion of entries and does not remove the indexing for those entries from the index. You must manually reindex those form types occasionally to remove deleted entries from the index.
- Searching conducted within filter workflow that involves qualifications with full text indexed fields can produce unexpected results if the searching depends on data that was created during the same filter sequence. Database searches can find data that was recently created, but full text searches cannot. To preclude the use of full text searching during a filter that conducts this type of search, select the Use FTS in Workflow option on the FTS tab of the AR System Administration: Server Information form. For more information, see FTS tab configuration options.
- Full text searches that involve a field reference to the right of the relational operator are not supported. A warning message occurs that indicates that the query was treated as a database query instead of an FTS query. The presence of
'Target'in the following example returns the warning message if the Short Description field is indexed for FTS:
'Short Description' LIKE 'Target' + "ing"
If no variables are to the right of the
LIKEkeyword in the statement, FTS handles the search. For example:
'Short Description' LIKE "block" + "ing"
In this example, the search is handled by FTS because the known values (block and ing) are combined to form one known value (blocking).