How do you filter and see tickets in progress that have gone over the requested due date?

[신주원]

Good evening, I'm an intern working in a digital strategy division. I am currently in charge of organizing issues/tickets so if there are tickets that are being delayed I need to reach out to request updates. May I know how to get that on my dashboard?

[Radek Dostál · Accepted solution]

You could probably use something like

project = X and duedate < now() and resolution is empty

or specific statuses such as 'status = "in progress"' or 'status in (.. , ..)', main point is in the 'duedate < now()'

There are more date functions other than now() if you want to e.g. look further in the past or for issues "nearing due date".