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