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 beginRole required: admin About this taskBy 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 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. ResultThe Search for text option appears on the list view for the table. Related TasksRegenerate a text index for a tableRemove an indexRemove an index for a specific fieldRelated ConceptsZing indexes punctuation as part of some wordsZing indexes some HTML elementsRegenerate a corrupt indexRelated ReferenceText indexing statistics and statusText indexing statistics and status
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 beginRole required: admin About this taskBy 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 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. ResultThe Search for text option appears on the list view for the table. Related TasksRegenerate a text index for a tableRemove an indexRemove an index for a specific fieldRelated ConceptsZing indexes punctuation as part of some wordsZing indexes some HTML elementsRegenerate a corrupt indexRelated ReferenceText indexing statistics and statusText indexing statistics and status