Keyword search issue - "Your text query contained only common words or ambiguous wildcards"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2023 11:33 PM - edited 01-15-2023 10:01 PM
Hi All,
While searching for a keyword it is showing the error - "Your text query contained only common words or ambiguous wildcards".
I have gone through the KBs - KB0868966 & KB0745116 and tried the resolutions.
- Tried by increasing the value for the system property - "glide.ts.max_wildcard_expansion".
- Tried by changing the particular word in table 'ts_index_stop_list' to "Not a stop word".
But still, it's not showing the proper output.
Can anyone guide me to resolve this issue.
Thanks & Regards,
Meenakshi
- Labels:
-
ITSM: General
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-22-2024 06:47 AM
It's basically warning you that you are using stop word in your query e.g. 'and' 'or' 'problem' etc.
You can resolve it by these options:
For Option 1:
1.1. Review the word is not a "Stop Word" in the following tables:
/ts_stop_list.do
/ts_index_stop_list.do
1.2. If the word is listed in any of this tables, edit the record and change the "Stop mode" field value to "Not a stop word."
For Option 2:
Increase the value for the "glide.ts.max_wildcard_expansion" system property. The default value is 500.
2.1. Go to https:[my_instance].service-now.com/ts_word_list.do
2.2. Search by the word, if the records are more than 500, then the word will act as "Stop Word" even when it is not listed in the tables mentioned in Option 1. Review KB0745116 for more information.
Also, refer to this KB:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0745116
Mark my answer correct & Helpful, if Applicable.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-22-2024 06:48 AM
Hello @Meenakshi Rajes
It's basically warning you that you are using stop word in your query e.g. 'and' 'or' 'problem' etc.
You can resolve it by these options:
For Option 1:
1.1. Review the word is not a "Stop Word" in the following tables:
/ts_stop_list.do
/ts_index_stop_list.do
1.2. If the word is listed in any of this tables, edit the record and change the "Stop mode" field value to "Not a stop word."
For Option 2:
Increase the value for the "glide.ts.max_wildcard_expansion" system property. The default value is 500.
2.1. Go to https:[my_instance].service-now.com/ts_word_list.do
2.2. Search by the word, if the records are more than 500, then the word will act as "Stop Word" even when it is not listed in the tables mentioned in Option 1. Review KB0745116 for more information.
Also, refer to this KB:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0745116
Mark my answer correct & Helpful, if Applicable.
Thank you.