Stream: IG creation
Topic: Jira query help - filter on Grouping
Carl Anderson (Feb 04 2021 at 23:14):
Apologies if there's a better stream to ask this question - please punt me in the right direction, if so.
I need help with a Jira issue filter. For my collection of ballot issues, I've been using the Grouping section to label ones I intend to address in an upcoming blockvote. However, I would also like to filter those tagged issues from my search. Unfortunately, I have not been able to make that work.
Here's what I have now.
status != Triaged AND assignee is EMPTY AND project = FHIR AND resolution = Unresolved AND Specification = "SMART Web Messaging (FHIR) [FHIR-smart-web-messaging]" ORDER BY priority DESC, updated DESC
My Grouping label that I'm looking to exclude is SWM-BV1. Adding this to the query filters out all results.
image.png
I've tried using the NOT IN operator, too, and I get the same thing.
Any ideas?
Josh Mandel (Feb 04 2021 at 23:52):
Ternary logic for the win.
Josh Mandel (Feb 04 2021 at 23:52):
I think you need to look for (Grouping != SMW-BV1 or Grouping is null)
Josh Mandel (Feb 04 2021 at 23:53):
(Or something like that; I forget the exact syntax.)
Carl Anderson (Feb 05 2021 at 00:04):
Ah, thanks. That works!
Last updated: Apr 12 2022 at 19:14 UTC
