Enable text indexing for a table

Administrators can enable text indexing on a table to allow users to search for string values from table records.

Before you begin

Role required: admin

About this task

By default, the system creates text indexes for the tables with a Text index record (System Definition > Text Indexes). For example:

Knowledge-related tables
Core-data-related tables
Connect-related tables
Task table
User table

Note: Whenever you create an index table, the system also creates Access Control Roles (ACLs) for new tables.

Text indexing can be a resource-intensive task that may take a while to complete. You may notice performance degradation or incomplete search results during index generation. To estimate text indexing duration, you can view historical statistics.

Procedure

Navigate to System Definition > Dictionary.
Click the table name to open the dictionary entry.

A table in the System Dictionary is a record that has a Table name but no Column name.
Select the Text index check box to enable text indexing for text fields on the table.
Click Update.
Click Generate Text Index.
The system schedules the table for text indexing, typically within a minute.

Result

The Search for text option appears on the list view for the table.

Versions

Contents