I have a requirement to fulfill, we have a "supercategories" field in the advanced search filters of the "Product" entity. The categories are divided into 4 stages, the first stage is the root category and has the second stage categories as subcategories, the latter have the third stage categories as subcategories and the latter still have zero subcategories but have products. What I need to do is this: EG:
If a first-stage category is specified in that field: SAP retrieves all child (second-stage) categories of the first-stage category level specified.
For each second level category, SAP retrieves all child categories (third level) of the second level category.
For each third-level category, it retrieves the products belonging to that category.
All this only if "supercategories" filter is present in the search filters otherwise the search should not change.
How can I override the advanced search and take that supercategories filter value and do my logic with it? Thanks a lot.
