Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Mohammed Afsar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 6, 2022

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

filters: Project / Labels

status : unresolved

duedate

1 answer

1 vote
Fabio Racobaldo _Herzum_
Community Champion
June 6, 2022

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 6, 2022

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_
Community Champion
June 6, 2022

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

Like Mohammed Afsar likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events