How to extract issues list which are unresolved beyond due date ?

Question

JQL Query or any filter to extract the issues with status as unresolved but due date is crossed.

filters: Project / Labels

status : unresolved

duedate

Fabio Racobaldo _Catworkx_ · Answer

@Mohammed Afsar ,

duedate < startOfDay() means that duedate has been crossed

issuecreated on the quater : created > startOfMonth(-N) - (where N is the month before the current one)

Mohammed Afsar · Answer

Hello @Fabio Racobaldo _Catworkx_

Thanks for the reply!

maybe i can re frame my question as

to Extract the overdue task with project filter and label filter with issue created on that quarter.

issues may have different due date so, extracting with startofDay() gives incorrect results

please suggest filter for extracting overdue tasks

Fabio Racobaldo _Catworkx_ · Answer

Hi @Mohammed Afsar ,

welcome to the Atlassian community!

Here a simple JQL that should match your desiderata :

project = YOUR_PROJECT_KEY_HERE and resolution is EMPTY and duedate < startOfDay()

Hope this helps,

Fabio