How to limit number of records in CSV export?

bmarkus

New Member
I have a table with 90,000 records. How can I limit number of records in CSV export? Need only say 1-2,000 or created on last few days. There is the 'Custom QS' and 'Include filters' options but how to use them is not clear. Practical example is appreciated.

Thanks... B?la
 
I don't think there is a way to limit the actual count. But you can edit the 'Fabrik List Options' parameters for the menu item containing the list and add a prefilter to limit the date. So if you would like to limit records to only the past 30 days, your menu prefilter would look something like this...
AND | date_time | GREATER THAN | DATE_SUB(NOW(), INTERVAL 30 DAY) | No quotes | Registered

Other DATE_SUB options... http://www.w3schools.com/sql/func_date_sub.asp
 
Last edited:
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top