Hello,
I save the status of task ticket into table. When date is overdue, the status has to change. But how do I achieve this?
I know that in some examples in context of expiry dates, this is done just using a view, or inside SQL query, instead of table reflecting whether its over specific date. But how do I achieve this if I need to have the status column, that should also capture a change if task date is overdue?