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

Kanban | Swimlane query | Show issues from multiple "Fix Versions"?

Kollgaard, Nicholas

Following some assistance from other folk in the community, I have evolved my original query to as per the below, which I want to use to pull issues belonging to either of the fix versions IDs.

project = CC AND issuetype in (Story, Task) AND (labels != TechImprovement OR labels is EMPTY) AND fixVersion is fixVersion in (78760, 74907)

Unfortunately, it isn't quite working and Jira is returning the following error: "Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'in'. (line 1, character 125)"

Thanks in advance!

PS. I was forced to create a new thread as the board wasn't accepting my replies in my other thread

Accepted answers

All comments

Nic Brough -Adaptavist-

What are you expecting "and fixversion is fixversion in (x, y)" to do?

I think you probably want just

and fixversion in (x, y)

Kollgaard, Nicholas

Sorry, not sure how I missed that one.

Query is now running, however, it's still placing "some" items that fall into my query bracket into an "Everything else" group. I can't work out why for the life of me..

Trudy P Claspill

Provide the details about the issues that are in the Everything Else group. What are their values for

project

issuetype

labels

fixVersion

Nic Brough -Adaptavist-

Computers are highly logical and don't think in human languages, it is very easy for us to give them a "simple" query and them no understand what we really want!

Now you have a working query, the question becomes "why does your issue not match the query"? Find a missing issue and work through how it works with your query.

Kollgaard, Nicholas

Hi @Trudy P Claspill

I found the problem. Big time user error, as you may have predicted !

Thanks all!

Kollgaard, Nicholas

Sorry guys - just one issue that I'd benefit from your experienced eyes over:

project = CC AND issuetype in (Story, Task) AND (labels != TechImprovement OR labels is EMPTY) AND fixVersion in (78760, 71958, 74907)

It's only returning issue types = "Story" and seemingly ignoring "Task".

I'm guessing my query is problematic here?

Trudy P Claspill

Do you have any Task issue types that are

- in the CC project and

- have either no value in Labels or if there are values then none of them are "TechImprovement", and

- has one of the three specified Fix Version values?

If you have one that you think matches the criteria but isn't being returned, please show us the details of that issue with the above details visible.

Kollgaard, Nicholas

Hi @Trudy P Claspill - Basically no "Tasks" are being returned. Even those "Tasks" with the fields you mentioned (from my query) with the exact same values (no more, no less) than those of the "Story" counterparts.

For the issue types = "Task" that I expected to be returned:

in the CC project = yes
have either no value in Labels or if there are values then none of them are "TechImprovement" = yes (no labels set)
has one of the three specified Fix Version values = yes

Thanks

Nick

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server