Issue with text/keyword search

[Abhijit4]

We are facing an issue with keyword search which seems to be working on one instance (our dev instance) but not working on the other instance (our UAT instance). I have attached screenshot from both instances below:

Can somebody help me to understand, what could be differentiable parameter in both instances which is causing this problem or what are the different reasons that keyword search doesn't work?

Note : We have already ran text indexing for that table in both instances.

[Aman Kumar S]

Hi @Abhijit4 ,

Check if indexing is enabled and up-to-date on the affected instance. Navigate to "System Definition" > "Text Indexes" and ensure that the appropriate indexes are present and not in a "Building" state. You can force a reindexing by selecting an index and clicking the "Rebuild" button if necessary.

Secondly,Compare the search configuration between the working (dev) and non-working (UAT) instances. Verify that the search plugins and settings are the same. Pay attention to properties like "glide.text.search_engine" and "glide.text.tokenize_on_index".