keyword search functionality is not working in the custom table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2025 03:48 AM
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:
- Navigate to System Definition > Dictionary (sys_dictionary).
- Search for our custom table and open the Collection record (the one where the "Type" is "Collection").
- Check the box for Text index.
- Click the Update button.
- Now see a related link at the bottom of the form called Generate Text Index. Click this link.
- 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:
- Navigate to System Definition > Text Indexes (ts_index_name).
- Search for our custom table.
- The State should be "Complete". If it's still "Building", wait for it to finish.
0 REPLIES 0