This documentation supports the 22.1 version of Action Request System.
To view an earlier version, select the version from the Product version menu.

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 is in the Ignore Words List, searching on the phrase the, database, request in 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 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 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 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 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).

Was this page helpful? Yes No Submitting... Thank you