Searching by 'Keywords' contains 'approval file' generates message 'Your text query contained only common words or ambiguous wildcards, please refine your search and try again'

david_erickson · ‎12-27-2017

One of our end users was having issues with this while trying to find incidents that contained the words. I tried a similar searches. The ones that worked:

search functionality

search approval

search file

approval functionality

approval search

Only using 'approval file' generated the message. All of my searches brought up the incident and a few other items with one or both of the words. I have not been able to find out why the partiuclar phrase 'approval file' generates the message. Can anyone help me figure out why it generates the message, and how i can make it work as it won't find the incident that has that phrase but finds other ones with different phrases.

shruti_tyagi · ‎12-28-2017

Hi David,

I forgot to mention about table 'ts_index_stop' This is stop word table when stop word auto-generate when they reach threshold.

Open this table and search for your word. If your word is there change stop mode to Not a stop word. If your current stop mode is 'Index but don't query' no need to regenerate test index. If your current stop mode is 'neither index nor query' regenerate text index.

Thanks

Shruti

If the reply was informational, please like, mark as helpful or mark as correct!

View solution in original post

david_erickson · ‎12-28-2017

That table has it. Thanks so much. Both words exceed the automated stop threshold. I really appreciate the help. Now, if I can figure out how to mark this as answered…..

Thanks in advance.

David Erickson

ServiceNow Administrator | Developer

817-525-7192 (Direct)

4001 Embarcadero Dr

Arlington, Texas 76014

david.erickson@gmfinancial.com<mailto:david.erickson@gmfinancial.com>

shruti_tyagi · ‎12-28-2017

Perfect. Check here

How To Mark Answers Correct From Community Inbox

Shruti

david_erickson · ‎12-28-2017

I was able to do it. Seems from the logged into HI, even though I though I recalled setting it to log me in from some pop up, it was not, so I did not have the options visible. Had to logon to make them visible. Must have been mistaken about the pop up. Thanks again.

Thanks in advance.

David Erickson

ServiceNow Administrator | Developer

817-525-7192 (Direct)

4001 Embarcadero Dr

Arlington, Texas 76014

david.erickson@gmfinancial.com<mailto:david.erickson@gmfinancial.com>

Aditya Telideva · ‎12-27-2017

hI David,

You can always suppress these Info messages by below method:

There is a 'gs.flushMessages();' call that you can make to clear any existing info messages and prevent them from being displayed. The challenge is going to be finding the right place to put the code so that it will eliminate the messages. In your case you might have to hack the UI pages and macros from the KB to make it work. Here's a link to the info message doc I created to explain this, and other info message calls.

http://www.servicenowguru.com/scripting/ui-info-error-message-cheat-sheet/

Also, if you have already deployed KB v.3 , (with stop words activated), it's a very common message. I have search for the source but it seems it comes from the part of ServiceNow "we" can't modify. Message key is ts_query_only_common.

You may choose from one of the following workarounds:

Remove the Similar Cases relationship if it is not required or used.
Update the related list not to execute the search, but only to show cases with the same category.

Hope this helps,

Aditya Telidevara