LHN - Facet Management - Queries and Tables Used

List of the tables used in Facet Filtering

Existing tables (till FEP4)

ATTR

SRCHATTR

SRCHATTRPROP

New tables (FEP5+)

FACET (SELECTION – for Multifaceted selection)

FACETDESC

FACETCATGRP  (.. SEQUENCE column to handle FACET sequence in LHN)

Use case of Facet Selection

• Facet remains in available filters list
• First value selected decreases counts for other facets
• Additional selected values increase counts for other facets
• Counts for multi-value facet remain the same

Management Centre ( to handle the facet attributes)

To View the facets associated with a particular category.

Query params-

_wcf.search.facet='$facet$';

_wcf.search.exclude.facet='$filter Facet$';

To pass the selected facet values to getData

<c:forEach var="facetValue" items="${paramValues.facet}">

                <wcf:param name="facet" value="${facetValue}" />