Display all subcatogry in facets IBM WCS

Displaying only child category facets of a browsed category

Displaying only child category facets of a browsed category helps limit the number of SQL queries for catalogs with a large number of categories.

Problem

Displaying only child category facets of a browsed category helps limit the number of SQL queries for catalogs with a large number of categories. Otherwise, there is a performance hit for browsing child categories within a category.

If the MAX_DISPLAY column in the FACET value is set too low, some categories might not work correctly.

Solution

To resolve this issue:

Set the MAX_DISPLAY column in the FACET table to -1.

Set the displayChildCategoriesOnly property to true in your custom wc-component.xml file. For more information, see Changing properties in the component configuration file (wc-component.xml) (Search EAR).

These settings ensure that only child category facets of the browsed category are displayed, and that the subcategories of the child categories are not faceted.

e.g To display all subcatogry in catogry landing page 

update facet set  MAX_DISPLAY  = -1
where SRCHATTR_ID in (select SRCHATTR_ID from SRCHATTR where IDENTIFIER= '_cat.ParentCatalogGroup'  and INDEXTYPE = 'CatalogEntry' ) ;