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

Configuring FTS by using the Server Information form

You can configure FTS by using the Server Information form only for on-premises deployments.

This topic outlines the configuration options for FTS  from the FTS tab of the AR System Administration: Server Information form. To view the FTS tab on the AR System Administration: Server Information form, you should have the Full Text Search  license configured.

Best practice

We recommend that you use the AR System Management Console to set the FTS tab configuration options. For more information, see Setting global and local level configurations using AR System Management Console.

Full Text Search configuration options

Important

This form shows the local level value of the configuration. If a local value does not exist, the form displays the global level configuration. If you modify the value on this form, the local level configuration value is modified. For example, if a configuration shows global level value and you modify the value by using this form, the local level value gets created for the configuration.

FTS tab fields

Field name

Description

Disable Full Text Searching

Controls whether the server uses the full text search engine for searching. When disabled, the server uses the search capability of the underlying database. This setting does not apply to multi-form searching. For information about ignore word list, see Configuring the Ignore Words List for FTS indexing.

Full Text Search Threshold

The maximum number of search results returned from the search engine. The default value is 10,000. To limit the number of search results (because of constraints on the computer where the search engine is running), reduce the threshold.

Best practice: We recommend that you update the value of Full Text Search Threshold from the AR System Configuration Setting form.

Indexing Failure Recovery Interval

Defines the number of minutes the server waits between periodic attempts to index entries that failed to index for an unexpected reason in a prior attempt. The default value is 60 minutes.

Temporary Table Threshold

During the processing of search results, the server creates a temporary table if the number of FTS matches reaches this value. If the number of FTS matches is less than this value, the server uses the SQL IN operator for a query on an existing table. The default value is 200.

Complex Search Threshold

During the processing of search results, the server combines results from subqueries to arrive at the final result set. If the number of rows created during processing exceeds this value, the server returns an error message indicating that the search is too complex. The default value is 1,000,000.

Indexer Server Group Signal Delay

Number of seconds before a signal is sent to the server that owns the full text indexing operation (if no signal is pending). When a server is not the owner of the full text indexing operation and generates indexing work, that server signals the server that is the owner of indexing. To reduce the frequency of signals sent, the signaling is conducted on a delayed basis. When indexing is generated, the server checks whether a signal is pending. If so, the server does not need to take any action. If a signal is not pending, the server creates a pending signal to be sent in the specified amount of time. If the full text signal delay configuration value is changed, the duration of any pending delay interval does not change. The change takes effect the next time a delay interval is started. Values are

  • Default—10 seconds
  • Minimum1 second
  • MaximumNone

Case

Defines whether full text searching is case sensitive or insensitive. This setting affects all fields indexed for full text search and affects how the indexes are built. Therefore, changes to this setting trigger an automatic re-index. The default setting is case insensitive.

The value for Case is updated by using the Full-Text-Case-Option setting from the AR System Configuration Setting form.

Search Options

Defines how the server modifies qualifications received from the client. The choices are

  • Force Leading & Trailing Wildcards
  • Ignore Leading & Force Trailing Wildcards
  • Ignore Leading Wildcards
  • Remove Leading & Trailing Wildcards
  • Query Unchanged (default)

Reindex

Initiates the re-indexing of all fields selected for full text indexing. This check box is disabled if a re-index is in progress. The dialog box must be redisplayed for the check box to become active following completion of the re-indexing.

Disable Full Text Indexer

Controls whether the server processes pending indexing tasks. When disabled, indexing tasks are still recorded for processing at a later time when indexing is enabled.

Use FTS in Workflow

Controls whether the server uses full text searches when executing queries during workflow that have full text indexed fields in the qualification. By default, this option is selected. If you clear this check box, the server uses the search capability of the database.

Support Exact Matches for Phrases

Defines whether the server supports exact matches for phrase searches. This setting impacts all the fields that are indexed for full text search and how the indexes are built. Hence, changes to this setting trigger automatic reindexing. In the default setting, the server does not support exact matches for phrase searches.

Exact match searches significantly increase the size of the full text indexes because all words in the Ignore Words List are indexed.

Ignore Words List

Defines which words are ignored during indexing.

Title Field Weight

Defines the relevancy weight for the Title field of a form in a multiple-form search. (See Configuring forms for multiple-form FTS.) A value of 1 is the baseline and provides a slight boost to the relevancy weight. If you leave the field empty, the weight is 1. To increase the weight, enter a positive number greater than 1 and less than or equal to 2000. To decrease the weight, enter any number from 0.9 to 0.1. To see a significant difference in the relevancy score, the weight will need to be changed by increments of 100 or more.

Environment Field Weight

Defines the relevancy weight for the Environment field of a form in a multiple-form search. (See Configuring forms for multiple-form FTS.) A value of 1 is the baseline and provides a slight boost to the relevancy weight. If you leave the field empty, the weight is 1. To increase the weight, enter a positive number greater than 1 and less than or equal to 2000.  To decrease the weight, enter any number from 0.9 to 0.1. To see a significant difference in the relevancy score, the weight will need to be changed by increments of 100 or more.

Keywords Field Weight

Defines the relevancy weight for the Keywords field of a form in a multiple-form search. (See Configuring forms for multiple-form FTS.) A value of 1 is the baseline and provides a slight boost to the relevancy weight. If you leave the field empty, the weight is 1. To increase the weight, enter a positive number greater than 1 and less than or equal to 2000. To decrease the weight, enter any number from 0.9 to 0.1. To see a significant difference in the relevancy score, the weight will need to be changed by increments of 100 or more.

You must re-index data so that any changes to the relevancy weights are applied to the existing data.

AR System  does not support Full Text Search  if you have read-only database. For more information on using read-only database, see Using read-only database.

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

Comments