If a list contains a prefilter the prefilter condition is overriding the condition in the normal list filter part.
Example:
prefilter: baustelle.date_time < (curdate())
list filter on "feld" (field element, filtertype field, exact match=NO) gives
WHERE ( baustelle.date_time < (curdate()) ) AND ( `baustelle`.`feld` < 'php' )
see also http://www.fabrikar.com/forums/inde...orking-on-a-list-based-on-a-mysql-view.37219/
----------------------------------------------
Other issue:
list without prefilter, just list filter on "feld" (field element, filtertype field, exact match=NO)
correct if filtered the first time
WHERE ( `baustelle`.`feld` LIKE '%php%' )
wrong if used again (just click "Go" again)
WHERE ( `baustelle`.`feld` LIKE 'php' )
Latest GitHub
Example:
prefilter: baustelle.date_time < (curdate())
list filter on "feld" (field element, filtertype field, exact match=NO) gives
WHERE ( baustelle.date_time < (curdate()) ) AND ( `baustelle`.`feld` < 'php' )
see also http://www.fabrikar.com/forums/inde...orking-on-a-list-based-on-a-mysql-view.37219/
----------------------------------------------
Other issue:
list without prefilter, just list filter on "feld" (field element, filtertype field, exact match=NO)
correct if filtered the first time
WHERE ( `baustelle`.`feld` LIKE '%php%' )
wrong if used again (just click "Go" again)
WHERE ( `baustelle`.`feld` LIKE 'php' )
Latest GitHub