marcelf
Member
I'm trying to use pre-filter. I need to the records that are too old using the a value of a field element.
First like in the fabrik wiki I tried:
http://fabrikar.com/forums/index.php?wiki/list-pre-filters/
> Show records created before the estimated days to do the job (overdue)
where:
field = your-date-element
condition: less than
value: NOW()- INTERVAL '{jobs_estimated_days)' HOUR
type=no quotes
It didn't work. '{jobs_estimated_days)' isn't recognized using "no quotes".
So I tried to use EVAL. My Problem: the placeholder isn't working in the pre-filter value. Look the filter below.
I also created calc field to test with same code. It shouldn't show any record, but its showing:
In the calc works, but in the value using EVAL of pre-filter don't. Is it a Fabrik bug ?
Another solution: how can I store the result of calc when the list is viewed?
Thanks,
Marcel
First like in the fabrik wiki I tried:
http://fabrikar.com/forums/index.php?wiki/list-pre-filters/
> Show records created before the estimated days to do the job (overdue)
where:
field = your-date-element
condition: less than
value: NOW()- INTERVAL '{jobs_estimated_days)' HOUR
type=no quotes
It didn't work. '{jobs_estimated_days)' isn't recognized using "no quotes".
So I tried to use EVAL. My Problem: the placeholder isn't working in the pre-filter value. Look the filter below.
I also created calc field to test with same code. It shouldn't show any record, but its showing:
In the calc works, but in the value using EVAL of pre-filter don't. Is it a Fabrik bug ?
Another solution: how can I store the result of calc when the list is viewed?
Thanks,
Marcel