Pre-filters
From Fabrik
Prefilters allow you to filter the data that is shown in the table.
Unlike element filters there is no user interface to interact with prefilters
Contents |
Common Examples:
Show all records older than a certain date:
where:
field = {your date element}
condition: less than
value: NOW()- INTERVAL 1 WEEK
type=no quotes
Show all records created in the last 6 hours:
where:
field = {your date element}
condition: greater than
value: NOW()- INTERVAL 6 HOUR
type=no quotes
Show records belonging to the logged on user
where:
field = {your user element}
condition: equals
value: {$my->id}
type=text
