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

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
1 answers

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.