Forums

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

Is there a way to create a JQL filter that compares 2 date fields, e.g. Duedate < Resolved

Tony Giovenali
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!
April 19, 2023

I am trying to filter for Bugs that were Resolved (marked as Done) after their Due Date. Is there a JQL query for this 

project = "myproject" AND issuetype = bug AND status = Done AND duedate < resolved ORDER BY issuekey ASC

1 answer

2 votes
Alex Koxaras -Relational-
Community Champion
April 19, 2023

Hi @Tony Giovenali and welcome to the community,

Unfortunately, you can't compare fields within the JQL.

What you can do, outside the box, is to use a JQL from an automation rule and compare the date field you want to another's date field smart value. E.g.:

project = "myproject" AND issuetype = bug AND status = Done AND duedate < {{issue.fields.resolved}}

The above can be accomplished, but as I mentioned only within an automation rule.

Suggest an answer

Log in or Sign up to answer