thellie
Member
Hi
I have a menu for various lists of volunteers - registered; current; past; latest; leaving, etc...
The 'latest' list denotes the latest intake to arrive, and I use 3 prefilters to achieve this (see pic).
In the first pre-filter, the query in full should be: (SELECT MAX(startdate ) FROM vol_appform WHERE startdate <= NOW())
but each time I save it, it knocks out the < from the query. If I change the query to ...startdate < NOW()... then it also removes the < leaving it as ...startdate NOW()...
This is not an issue in the Fabrik List Module, only the List Menu. I have attached another pic with the two lists together (List Menu on top). The <= does not get knocked out of the List Module prefilter query...
I have a menu for various lists of volunteers - registered; current; past; latest; leaving, etc...
The 'latest' list denotes the latest intake to arrive, and I use 3 prefilters to achieve this (see pic).
In the first pre-filter, the query in full should be: (SELECT MAX(startdate ) FROM vol_appform WHERE startdate <= NOW())
but each time I save it, it knocks out the < from the query. If I change the query to ...startdate < NOW()... then it also removes the < leaving it as ...startdate NOW()...
This is not an issue in the Fabrik List Module, only the List Menu. I have attached another pic with the two lists together (List Menu on top). The <= does not get knocked out of the List Module prefilter query...