Conditional Value in Data Grid Row

0
Hello Experts, Is it possible to set the Data Grid Value Conditionally in Mendix ? lie if you see my below example. I have to set the status value ‘Expired’ if expired date is less than current date else set default status attribute value. 
asked
3 answers
2

You could have two status attributes. One stored and one calculated. The stored one is used to store the status (independent from the date). The calculated one is set to the stored value if date is not less than current date. Otherwise it is set to Expired. In your datagrid, you can only show the calculated one as it always reflects your need.

answered
1

You could use a calculated field for it but that has some performance drawbacks. How many rows are we talking about?

Otherwise you have to make sure that you recalculate the status on a daily basis (scheduled event running each night that recalculates the status).

Regards,

Ronald

 

answered
0

How can i setup a schedule event running?

answered