DURING jql issues

[Jenny Wheatley]

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]

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]

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. 

[Sreenivasaraju P]

Hi @Jenny Wheatley ,

Can you please try below query 

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

[John Funk]

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