Hello, I am trying to create a JQL query to retrieve unresolved /in progress JIRA issues from 2021

[Kristofer.Appel]

project = XYZ AND issuetype in ("Data Integrity") AND created >= 2021-01-01 AND created <= 2021-12-31 AND summary !~ "%Test%" AND resolution = Unresolved ORDER BY cf[32615] ASC, cf[53101] DESC, created ASC

This is what I have, but when applied it states there is no data available. Any ideas?

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

My guess would be that it is genuinely unable to find any matching issues.

Try removing one clause at a time, to see if the resulting query finds you anything of any use.

I would start with the "and summary !~" because that's a fuzzy text search and is most likely to be the one that could be excluding a lot of issues 

[Kristofer.Appel]

Thankyou!

[Walter Buggenhout · Accepted solution]

Hi @Kristofer.Appel and welcome to the Community!

The most likely culprit is the summary !~ "%Test%" part. Try your query without that part first to see if there are unresolved issues. If that works, leave out the % signs.

Another great trick would be to create a Dashboard and put a Recently Created chart gadget on it with Project XYZ as its source. It wil show issues created relative to the month (or week or ...) they were created in. Open issues will be shown as red on the chart. The only caveat there is that it can only go back 300 days in the past, so its not a full blown solution for your use case, but an interesting one to remember.

Hope this helps!

[Kristofer.Appel]

Thank you!

[mauricio.groth]

Hi @Kristofer.Appel 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this function to find all your issues that haven’t the word Test in the summary

issue not in wildcardMatch("summary", “Test*”)

Check out the documentation for more examples.
I hope this helps!
Maurício