Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Enable text indexing for a table

Log in to subscribe to topics and get notified when content changes.

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.


  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.


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