Keyword/"For text" search does not work for Interaction table

Victor17
Giga Contributor

‎11-03-2021 04:47 AM

Hi all,

 

Keyword/For text search does not seem to work on the interaction table. 

 

I.e.

After searching for "test" in the image below, I'd expect IMS00000101 to appear (as the Short Description contains test).
find_real_file.png

However, this is my result:
find_real_file.png

Does anyone know why this is not working? 

Preview file
25 KB
Preview file
27 KB
  • 1,649 Views
2 REPLIES 2

Hannes2
Kilo Contributor

‎12-06-2021 05:46 AM

I've tried in several different customer instances and my own PDI, same issues on all them regardless of patch/release. Seems like a native issue that ServiceNow has to fix on their end...

yannickga
ServiceNow Employee
ServiceNow Employee

‎01-10-2022 11:10 AM

I was able to fix the issue on my personal instance by indexing the interaction table. Open the Dictionary for the Interaction table (Type=Collection):
https://<YOUR INSTANCE>.service-now.com/nav_to.do?uri=sys_dictionary.do?sys_id=97ffbe54db033300f5c356f3ce961907

Click on the related link "Generate Text Index" and this should fix the issue

You can find the text index events for that table here, navigate to the sysevent table (sysevent.list), and look for name = "text_index" and table= "interaction":
https://<YOUR INSTANCE>.service-now.com/nav_to.do?uri=%2Fsysevent_list.do%3Fsysparm_query%3DtableSTARTSWITHinteraction%26sysparm_first_row%3D1%26sysparm_view%3D%26sysparm_choice_query_raw%3D%26sysparm_list_header_search%3Dtrue