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

How can I filter out tickets with status = Canceled

Gavriel Fleischer

I am not able to filter out (exclude) the tickets with status: CANCELED .

I have a filter, where I am able to filter out certain statuses using:

assignee = currentUser() AND status NOT IN(Closed, Done, Backlog, "To Do", Cancelled, Canceled, PROD, "on hold", Pending, "Pending Devops", "pending DB team") AND "Epic Link" = EMPTY AND type != Epic AND parent is EMPTY AND (labels != waiting OR labels is EMPTY) AND project != "Server Design Board" ORDER BY priority DESC, rank ASC

But I still see some tickets in the results with status: CANCELED

Any idea how can I filter them out?

(No, adding "AND status != CANCELED" doesn't help)

Accepted answers

All comments

Kai Becker

Hi @Gavriel Fleischer

thanks for your question. Most of the time there is an logical issue with the JQL. Would you mind pasting the whole JQL query, so we can have a closer look?

One thing to add right now: There is an easier way in excluding status. You can put them all together like this:

status NOT IN (Closed, Done, Backlog, ...)

Vickey Palzor Lepcha

Can you share the first half of the jql too ? Ideally , I can see that your JQL should work unless it is picking issues from multiple projects ?

Gavriel Fleischer

Thanks, Kai,

1st of all I modified it now to use the NOT IN, thanks for that tip. Here's the query:

As you might guess there are multiple projects in our company, and each team sets up their project differently, thus so many statuses (including typos). My problem is that the above query still returns tickets with status: "CANCELED"

Gavriel Fleischer

Added the full query. Indeed it is picking up tickets from multiple projects. That is the reason why there are som many excluded statuses, because each team sets up their project differently

Kai Becker

Hi @Gavriel Fleischer
thanks for the update. Just to make sure. Are these Company Managed Projects or Team Managed?

The next step I would take: start the JQL just with the user and status part. Check if there are still issues with CANCELED and then go on and add each part next to identify which part brings them in.

Gavriel Fleischer

I don't know if they are company or team managed (or what are the differences between them or how I can tell them apart)

I also don't really understand your recommendation regarding how to debug it. I mean if I understand what you mean then that's the way this query was built. I had only the user, then filtered out more and more things as new tickets showed up that I didn't want to see in the filter. And it kind of works. It does filter out lots of tickets in different projects with all those statuses.

Can it be that some projects defined the status as Canceled, others as canceled or CANCELED and the filter is case sensitive, but the way it is displayed I only see them capitalized?

Though even then when I type "AND status != C..." I see the UI gives me suggestions, so maybe there is the bug, that I am supposed to see another one, but either in the suggestion or in the filter somewhere the case sensitivity is lost?

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