Usecase product list filter in E-commerce web app

Hello everyone, I have a usecase and hope you can help me find a solution
I have a Product index, with fields brandId and categoryId,..., I need to filter by many brandId and many categoryId and aggregate by brandId and categoryId to get the available options.
I created a query filter to get the product

And for each filter (brandId, categoryId,...) create an aggregate query to get the available options for each filter

Is there a more effective way? Please let me know
thank you very much

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.