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

[Nick]

Hi all,

Getting closer to my perfect Kanban board. Have a question on how I can fix my query to return any issues in a given swimlane, particularly where the3 issues are assigned to any of the "Fix versions". What I have:

project = AA AND issuetype in (Story, Task) AND (labels != TechImprovement OR labels is EMPTY) AND fixVersion in ("Q1", "Q2")

It does seem to be pulling in SOME issues that have either of these "Fix version" values, but not all, and I can't work out why it's only pulling in some selective ones?

Thanks in advance,

Nick

[Hana Kučerová · Accepted solution]

Hi @Nick , 

hopefully I understand your request, please try: 

project = AA AND issuetype in (Story, Task) AND (labels != TechImprovement OR labels is EMPTY) AND fixVersion is not EMPTY

[Nick]

Hi @Hana Kučerová,

Thanks for your effort here. Not quite what I need, though.

I am trying to return issues belonging to two specific "Fix versions". Let's call them "Q1" & "Q2".

Hope that makes sense?

Thanks,

Nick

[Hana Kučerová]

Ah, I see, thank you @Nick .

I think the most “safe” way is to use release version ids instead of names: 

fixVersion in (id1, id2)

[Hana Kučerová]

Id can be for example obtained from the URL of release detail.

[Nick]

Hi @Hana Kučerová - Thanks for your help. I found the "Fix version" IDs from their respective URLs, as you suggested, and this is what I am trying based on your last two responses:

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

But the error I'm getting back is: "Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'in'. (line 1, character 125)"

Any idea?

Thanks again! I am so grateful!

[Nick]

Hi @Hana Kučerová - thanks for your assistance again on this one. I found the IDs from the "Fix version" URLs, as you suggested, and I updated the query to be:

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

But, Jira is still returning an error. This time, the error reads: "Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'in'. (line 1, character 125)"

Please let me know where you think I'm going wrong.

Thanks in advance - super grateful for your kind support here.

[Hana Kučerová]

Hi @Nick ,

I believe the correct syntax is:

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