nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

unknown

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?

Accepted answers

Nic Brough -Adaptavist-

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

Walter Buggenhout

Hi @[deleted]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!

All comments

Nic Brough -Adaptavist-

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

Walter Buggenhout

Hi @[deleted]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.

Hope this helps!

unknown

Thank you!

unknown

Thankyou!

mauricio.groth

Hi @[deleted]

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud