Limitations of FTS
The following limitations apply to a Full Text Search:
Category | Description |
|---|---|
Punctuation marks | In accrue searches, you cannot search for most punctuation marks because they are treated as word separators. |
New or modified requests | New 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. |
Deleted entries in certain form Types | The indexing of fields on form types such as join, vendor, and view forms where data is updated outside of AR System, does not automatically update deleted entries. |
- In accrue searches, you cannot search for most punctuation marks because they are treated as word separators.
- New 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 such as join, vendor, and view forms where data is updated outside of AR System, does not automatically update deleted entries.
These form types require manual scanning for changes and does not remove the deleted entries from the index. You must manually re-index 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 Configuring-FTS-by-using-the-Server-Information-form.
Full text searches that involve a field reference to the right of the relational operator are not supported. A warning message indicating that the query was treated as a database query and not a 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 LIKE keyword 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).