Question

How to add default value of date interval in search filter in Datagrid

1

Hi, I have a datagrid with a lot of data. In order to reduce load on database I would like to add a default time interface as a default value in the filters of a datagrid. e.g. From date = [%CurrentDateTime%] && To date = adddays[[%CurrentDateTime%],30] I cannot add this condition into the xPath, because the user must be able to adjust the interval later. Thanks! Panayu

asked 2011-01-28

Panayu Sirikrachangsri

1 answers

Pieter van de Braak · Answer 1 · 2011-01-28

As far as i know you cannot use functions in the default value for search fields. Thus you won't be able to just add 30 days. However changing the amount of rows your datagrid displays should reduce the load on your database.