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

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

  1. Navigate to System Definition > Dictionary.
  2. 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.

    Table in the System Dictionary
  3. Select the Text index check box to enable text indexing for text fields on the table.
    Text index check box
  4. Click Update.
  5. 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.