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.
Full Text Search configuration options
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
|
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
|
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.