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

[Mohammed Afsar]

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 _Herzum_]

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

[Mohammed Afsar]

Hello @Fabio Racobaldo _Herzum_ 

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 _Herzum_]

@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)