In datagrid need to date filter

0
Hi All,   I have scheduler Overview page, in that i want show only last 90days data (9.6.10 Version). Can someone please help me how add such filter for Datagrid. Thank you in Advance. Hemlata 
asked
3 answers
1

Hi hemlata,

in the datagrid take microflow as datasource,

retrieve your entity in the xpath

[createdDate>=addDays([%CurrentDateTime%], -90)]

 

This will work hope you like the answer.

answered
0

Hi Hemalath,

 

For Same day, week, month, Year we have the below options,

[createdDate>='[%BeginOfCurrentMonth%]'][createdDate<='[%EndOfCurrentMonth%]']

 

But if you put list view inside one data view then you can take value from currentobject so there you can pass any date as start date, addMonths([%CurrentDateTime%],-3),

image.png

Hope it helps!

Thanks & Regards,

Manikandan K

answered
0

Hemlata,

Another way to do this is using time related XPath tokens.  Using XPath as a datasouce, you would add this constraint:  

[createdDate >= '[%BeginOfCurrentDay%] - 90 * [%DayLength%]']

Documentation for these tokens can be found here:  https://docs.mendix.com/refguide/xpath-keywords-and-system-variables/#time-related

Hope that helps,

Mike

answered