Limit Output Results by Criteria in DB Field

I have a product database of over 40k records, I want to export an excel sheet of all items from a specific brand, whats the best way to accomplish this?

Thanks

Well, I've found my own answer, thought I'd share it

In the read file > configure adapter, insert something to the effect of

select * from WHERE BRAND="Brand"

into the SQL tab under Fields/Data types.

Thanks for sharing your solution.

Just let me add some remarks.

1. In your SQL WHERE statement you could also use FlowHeater Parameters like this
   
   select select * from WHERE BRAND = "$BRAND$"
   
   In this case you can override the parameter value with the Batch Module option /SetParameter BRAND=otherBrand


2. Another way to filter some records is to use the Filter Heater together with the IF-THEN-ELSE Heater for the filter condition. Here you’ll find two examples how you could to this.
   
   NOTE: Your used way is much faster because in this case FlowHeater hasn’t to proceed the whole records.