can we setup a default filter/search base on today date ?

PHPMaker General Discussion (PHPMaker)
1

hi,

i need to display a list of dates in the listview.
i wish the user can see by default, only the lines with this condition (today-30<=date<=today+30)
i know i can build a view with sql condition like that, but i need the user can also see other date over 30 days too ! i just want to fix the default interval to 30days +/-

Thank you for your help.

2

xxltomcat wrote:

What type of database do you use?

i use mysql but it is not the point, i don’t want a filter, i want a default search in phpmaker.
if i perform a WHERE CLAUSE inside sql, the clear filter action would not show all …