Remove the text index for a child table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • You can remove the text index for a child table if you no longer want the search engine to return results for that child table.

    Before you begin

    Role required: admin

    About this task

    The Text index option for a table is inherited by all of that table's child tables. Clearing this option for an individual child table has no effect.

    For example, Text index is selected for the Task table in the base system. This setting enables text indexing for the Task table. All tables that extend Task, such as Catalog Task, Incident, and Request, inherit this option. Clearing the Text index option in the Incident child table doesn't disable text indexing for Incident records.

    To disable text indexing for a specific child table, set that table's No text index attribute. This attribute overrides the table's inherited Text index option without affecting indexing behavior for other tables in its hierarchy.

    Procedure

    1. Navigate to All > System Definition > Dictionary.
    2. Open the dictionary record for the child table.

      The dictionary record for a table is the record with an empty column name and a Type value of Collection, as shown in the following example image.

      Dictionary Entry table showing a table's dictionary record with empty Column name and Type value of Collection.

    3. In the Attributes related list, select New.
    4. On the Dictionary Attribute form, fill in the fields:
      Field Value
      Attribute No text index
      Value true
    5. Select Submit.
    6. Select Update.

    Result

    The system no longer indexes or queries the child table for text search results. Indexing continues for other tables in the table's hierarchy.