Key Word Search in Data Table widget not working on all tables

[km14]

 I have observed that that using the existing Data Table widget --> Click on View All Tickets --> Keyword Search, works for well for tables.This functionality is not working for custom table created.Getting No records in <<table name>> using that filter.Could you please let us know if there is any configuration that needs to be done for this?

[AbhishekS7792]

keyword search functionality is not working in the custom table

Solution:

1. Enable Text Indexing for the Table:

• When keyword search doesn't work on custom tables. We needs to index the text fields of our table to make them searchable.
• Steps:
  1. Navigate to System Definition > Dictionary (sys_dictionary).
  2. Search for our custom table and open the Collection record (the one where the "Type" is "Collection").
  3. Check the box for Text index.
  4. Click the Update button.
  5. Now see a related link at the bottom of the form called Generate Text Index. Click this link.
  6. ServiceNow will start indexing your table. The time it takes depends on the size of our table. We can monitor the progress in System Logs > Events by looking for events with the name text_index and our table name.

2. Verify Text Index Completion:

• Ensure the text indexing process has finished before testing the search.
• Steps:
  1. Navigate to System Definition > Text Indexes (ts_index_name).
  2. Search for our custom table.
  3. The State should be "Complete". If it's still "Building", wait for it to finish.