Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Limit Output Results by Criteria in DB Field

Limit Output Results by Criteria in DB Field 2 years 5 months ago #2329

  • B.Greenway
  • B.Greenway's Avatar
  • Offline
  • New Member
  • Posts: 4
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
The administrator has disabled public write access.

Limit Output Results by Criteria in DB Field 2 years 5 months ago #2330

  • B.Greenway
  • B.Greenway's Avatar
  • Offline
  • New Member
  • Posts: 4
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.
The administrator has disabled public write access.

Limit Output Results by Criteria in DB Field 2 years 5 months ago #2331

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.075 seconds