Our use case is to design product filters on search page (2nd page) like Amazon or any other e-commerce shop. Please see screen shot. Product should be filtered on these scenarios. Internal filters like TV, Fridge should be filtered to "OR" condition and outside filters Brand, Category based on "AND" . Do we need to write aggregation and aggregations. Please share sample query in JSON . Your help is appreciated.
Query should be like this: Select (Category= "TV" OR "Fridge" ) AND (Brands=LG or Samsung)
@Elastic Team- Please share sample queries which you have already shared for similar discussion or url.