How to filter issues that are resolved by the common end date(due date)?

[신주원]

Hi, I'm looking for a way to filter jira tickets created in the year 2024, that are resolved by the common end date (due date). What would be the query code for it? 

Currently I've got this code below but I need to know which ones were resolved without delay.

project in ("[AP_OPR] AP 브랜드웹 운영") AND issuetype != Epic AND createdDate >= 2023-01-01 AND filter = 21403 AND created >= 2024-01-01 AND resolution is not EMPTY 

[Ragavendran S]

Hi @신주원 ,

Good day there!

based on what I understand, your need is to find the issues which are resolved in the due date without any delay!

In my project setup, we have a field called "Target End Date" - where we will mention the due date for that ticket. it will be used to validate whether it has been resolved within the mentioned time or not.

I assume that field is common to Jira, rather than user specific. if you have that field, and you have provided the value for that field, you can try this query.

project in ("[AP_OPR] AP 브랜드웹 운영") 
AND issuetype != Epic 
AND createdDate >= 2023-01-01 
AND filter = 21403 
AND created >= 2024-01-01 
AND resolution is not EMPTY 
AND targetEndDate <= resolutionDate 
ORDER BY resolutionDate ASC

let me know if it's working!

[신주원]

Hi @Ragavendran S , 

Good morning!

Thanks for the help. I've tried the query by adding some specific Target End Date and resolution date but it says I've got 0 corresponding issues. Seems like I'm not doing something right. I'll try some other things out and see if I can find a solution. 

[vaibhav raverkar]

Try this

project = "Project Name" AND type != Epic AND duedate <= 2024-04-20 and duedate >= 2024-04-19 AND resolution != resolved

You can play around with the dates to narrow down your search.