Use regular expressions to define your query. E.g. you want to find all products which cocts more than 20 USD, is located in category containing word “jacket” and with “Adidas” brand. You would then search:
PRICE_VAT > “20” AND CATEGORYTEXT ~ “jacket” AND MANUFACTURER = “Adidas”
Choose whether you want to search in input/output data and limit the search to “not-hidden products only” and/or ”products with manual changes only”.
Make sure you save the created query so that you are able to apply rules to that query etc.