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

신주원 April 24, 2024

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 

2 answers

0 votes
Ragavendran S April 24, 2024

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!

신주원 April 25, 2024

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. 

0 votes
vaibhav raverkar April 24, 2024

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events