- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-27-2023 05:33 AM
Based on this documentation
Wildcard characters allow searching for patterns and variations (servicenow.com)
we activated Wildcards (e.g. *) in the (Zing) search for our Knowlegde Base via Service Portal with this result:
- Searching for a string with a wildcard at the end (like clipboar* to find results for clipboard) works as expected within less than 2 seconds. -> OK
- Searching for a string with a wildcard at the beginning (like *lipboard) also opens the expected results (here 2 matches) but with a searching time of > 2 minutes. If I use % as leading wildcard (%lipboard), the search takes ~1,5 minutes.
Did anyone experience similar or can give me a hint what could be wrong (we're currently on Utah)
Thanks
Joachim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-19-2023 08:12 AM
The reason and workaround is described here:
Zing searches with leading wildcards trigger inefficient queries - Known Error (servicenow.com)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-19-2023 08:12 AM
The reason and workaround is described here:
Zing searches with leading wildcards trigger inefficient queries - Known Error (servicenow.com)