In-Portal is capable of searching across whole Catalog data (e.g. categories, links, products, etc.). Each searchable entity has:
- site-wide unique identifier - the "ResourceId" column
- type - the "ItemType" setting is associated unit config
Using above information it's possible to count found entities of a given type. When displaying found entities the "ItemType" isn't taken into account, because "ResourceId" column is unique.
Unfortunately such approach results in incorrect counters on custom projects, where items without site-wide unique identifier are found and we're forced to use they auto-increment primary key value, which overlaps for multi-entity searches.
Solution
- in the "\kCatDBEventHandler::getTypeClauses" method, when joining "search_result" table also apply "search_result.ItemType = ..." filter in the "ON" clause
- in the "\CategoriesEventHandler::SetCustomQuery" method, when joining "search_result" table also apply "search_result.ItemType = ..." filter in the "ON" clause