<h2>Catalog search is not working as expected. Results are not getting displayed even for the exact matching item.</h2><br/><div style="overflow-x:auto"><article><div ><h3 >Issue </h3><section><ul style="list-style-type: square;"><li>Catalog search for a catalog item is not working as expected. Results are not getting displayed even for an exact matching item.</li></ul></section></div><div ><h3 >Release</h3><section><ul style="list-style-type: square;"><li>NY Patch 4 HF1.</li></ul></section></div><div ><h3 >Cause</h3><section><div id="1579105530.002200"> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div> <ul style="list-style-type: square;"><li>Reviewing the logs, it's discovered that only 1 catalog item was fetched not 2 and noticed that SQL was fetching only single record.</li></ul> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div></section></div><div ><h3 >Resolution</h3><section><ul style="list-style-type: square; list-style-position: inside;"><li>Issue could be related to indexing.</li><li>Better to generate index again.</li><li>Please Refer this document, <a title="TextSearch" href="https://docs.servicenow.com/csh?topicname=t_EnableATextSearchOnATable.html&version=latest" rel="nofollow">TextSearch</a>.<br /><br /><br /><br /></li></ul></section></div></article></div>