keyword search functionality is not working in the custom table

AbhishekS7792
Tera Contributor

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.
0 REPLIES 0