Wrong Search Result match count in Global Search - ESS

[Ruchi19]

we have a global search which searches from Catalog and Knowledge tables. but it displays the incorrect number of matching results on ESS page.

When it says, 11 results found, it displays only 7 results. So the Count of found results and actual display of results do not match. Any idea how to fix this?

[john_roberts]

This appears to be a bug with catalog items that do not have a category being included in the count, but excluded from the result list. We are looking into this.

[john_roberts]

A quick fix would be to modify the search group and add filter of category is not empty in the catalog text search table record. This should correct the count to match the results.

[Ruchi19]

Thanks a lot John. I tried that but looks llke still not working.

I have 3 filter conditions on sc_cat_item table currently.

1).Active is true
and no search is false
and category is not empty.

is something missing?

[john_roberts]

Items from the catalog are not displayed (catalog or search) if the item category is inactive. Looking at your dev instance shows that the items not displayed are in categories that are inactive. So you might want to add another filter for category.active=true to get the count to display correctly.