I noticed that in the past this was requested but didn't get enough votes.
But in 5 years a lot can happen so I hope it's possible to ask for this functionality again?
I have a grid with a lot of data and I want to be able to show all the records with date A and maybe next I want to see all records with date B.
I can make prefilters but a prefilter only accounts for e.g. “today” of a seperate one for “yesterday” but not dynamically for x days ago.
For this I've added a filterform and I would like to be able to set the date dropdown to a default value of today.
I hear you say, use a prefilter for “today” and let the user pick a different date from the filterform when they need a different date.
My experience is that the customer starts calling me because no records are found because he filters for “2014-02-14” AND the prefilter for “today” is also on.
I'll tel them to use the “turn of prefilters chackbox” or manually turn of the “today” prefilter but there are many users and even those I’ve instructed before tend to forget it.
Currently I disabled the prefileter and accept that the user manualy needs to pick today from the filterform date dropdown. But it would be much more conveniant if the date was by default today.
I've limited the amount of records to 2000 because otherwise all current 205725 records are read every time the window opens. Unfortunately some days 2000 isn’t enough to hold all records for “today”…
