Optimize open workflow tasks widget sorting

Original customer issue:

Nowhere in the dashboard do I get to see only the contents for which it is my turn to complete a workflow task.

Feel free to let me know if there is a solution for this.

In the content attached, he is the next in line. But I can’t see the task anywhere

I was expecting it to see under “today” or “open” on the workflows tasks dashboard, but it's not there

Solution:

• We will have a new database column on contents_workflow_tasks named “active_at”. This timestamp will be updated with NOW() whenever this task will be the next within the workflow

• We will split “Open” tab into to “Open (with due date)” and “Open (without due date)”

• With due date will filter all open tasks having due date set to > 7 days, ASC

• Without due date will filter all open tasks having now due date, active_at ASC