Full Text Search Settings

Confirm web interface supports full text search for Enquiry search and customer address. This enables faster search of Enquiry and customer address in the web interface.

Before enabling the full text search, Confirm Database need to be configured

Configuring SQL Server for enabling full text search

The instructions mentioned here must be followed, to enable full text index feature in SQL server.

Note: Ensure the windows service 'SQL Full-text Filter Daemon Launcher' is running and it's startup type is set to Automatic.

Configuring Oracle Server for enabling full text search

The instructions mentioned here must be followed, to enable full text index feature in Oracle database.

In Oracle, for every schema user (that needs to use full text search) in the asset_type table, following things are needed:
  1. The database user needs to be given the role of CTXAPP (to allow them to create/manage full text preferences/indexes.
  2. Execute permissions need to be given for the oracle text packages CTXSYS.CTX_CLS, CTXSYS.CTX_DDL, CTXSYS.CTX_DOC, CTXSYS.CTX_OUTPUT, CTXSYS.CTX_QUERY, CTXSYS.CTX_REPORT, CTXSYS.CTX_THES, CTXSYS.CTX_ULEXER.
Once the database configuration has been done, the following settings need to be enabled in the to enable full text search in the web interface:
  1. The 'Address' checkbox needs to be selected to enable full text search for customer address.
  2. The 'Enquiry' checkbox needs to be selected to enable full text search for Enquiry.

This will add the Full Text Index agent in the Scheduled Tasks. The Full Text index agent creates and maintains the full text index on Enquiries and customer address

After the index has been created, full text search functionality will be used in the web interface for searching Enquiries and customer address.

If the 'Enquiry'/'Address' checkbox is deselected, the full text search is disabled for Enquiry/Address and the corresponding index will be deleted.