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; } } }

JIRA(JQL) filter related

Chandrashekhar Kavi

I am not JIRA admin, I can see different columns with same name in exported xls from jira issues, now when I am trying to filter that sprint is empty it's not filtering all the records, how to get relevant result?

Accepted answers

All comments

Boyan Iliev_7n6lmk

Hi @Chandrashekhar Kavi , can you provide some details:

What are you trying to achieve in general? Get a list with all tickets in a project that do not have assigned sprint?
Are you trying to filter "sprint is EMPTY" in JQL or in the exported data?
What kind of tickets you get, that you expect to be filtered out? Were they in a sprint that was closed in the past?
Can you give an example of the "same name" columns? Is it something like "Comments 1", "Comments 2", "Comments 3", etc?

Chandrashekhar Kavi

Thanks Boyan, It's now done, I am not able to explain how it's done due to it's showing the above message while replying!

JQL, I used is as below.

Chandrashekhar Kavi

Sorry Boyan, I am still facing the issue as when exported rows using the previous JQL, it's still showing some issues which are having values in sprint column in xlsx!

Please refer images attached in this message.

Chandrashekhar Kavi

Please also refer the image for more reference

Boyan Iliev_7n6lmk

Ok, so I'm mostly on the same page. Please do try replacing "Sprint is Empty" with "(Sprint is Empty or Sprint not in (OpenSprints(),futuresprints()))" and let me know if you get what you are looking for.

Chandrashekhar Kavi

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