DURING jql issues

Question

Hello. I am having an issue with a JQL, could I please get your assistance/advice. I am trying to see all project tickets that were unresolved between X and Y dates, using the DURING function. This is the JQL I am using:

project = "GD" AND (createdDate >= 2024-04-15) AND resolution WAS Unresolved DURING (2024-07-01, 2024-08-01)

It is not returning any results. Can you please tell me if I have written the JQL incorrectly (and if so, how to correct it), or if this is an issue/bug on Atlassian's end that I should be aware of.

Thank you

Marc -Devoteam- · Answer

Hi @Jenny Wheatley

This JQL works for me I just changed the dates a bit and excluded a project.

createdDate >= 2024-01-01 and resolution was empty DURING (2024-07-01, 2024-08-01)

@John Funk Unresolved, does indeed not work.

John Funk · Answer

Did you actually try that @Sreenivasaraju P ? Because I don't think that field can be empty -Unresolved is not empty.

John Funk · Answer

Hi Jenny - Welcome to the Atlassian Community!

There might be a bug there. However, I used WAS NOT Unresolved and it gave me issues with the value of Unresolved.

You might actually use Status instead of Resolution and WAS NOT IN. Like this:

Status WAS NOT IN (Done, Canceled, Completed)

Whatever the Done category statuses are for that project.