How do i show all active bugs in multiple releases?

[Sam Sa]

I'm trying to use this code but it doesn't show all the bugs.  it also shows epics and stories.

can anyone please help?

project = Eagle AND issuetype= bug AND fixVersion = "Release 1" OR fixVersion = "Release 2" or fixVersion = "Release 3"

[Nic Brough -Adaptavist- · Accepted solution]

Re-read the query.

In plain English (and remember that punctuation matters), you are asking for

All bugs with a fix version of release 1 in project eagle, or anything with release 2 or release 3 on it.

I think what you actually wanted to say was

All bugs in project eagle with a fixversion of release 1, release 2 or release 3

The JQL for that is

project = Eagle AND issuetype= bug AND ( fixVersion = "Release 1" OR fixVersion = "Release 2" or fixVersion = "Release 3" )

[Sam Sa]

got it.  thank you so much.

[Ste Wright]

If you want to consolidate this JQL, you can also use this format:

project = Eagle AND issuetype = Bug AND fixVersion in ("Release 1", "Release 2", "Release 3")

Ste

[Sam Sa]

i also wanted to add a piece to report only non canceled, done, closed bugs.  This doesn't seem to work though....

project = Eagle AND issuetype = Bug AND fixVersion in ("Release 1", "Release 2", "Release 3") and status != (done, closed, canceled))

[Ste Wright]

Hi @Sam Sa 

When using multiple values in brackets, you need to use IN / NOT IN rather than = / != (which are for single values only).

So the JQL would be:

project = Eagle AND issuetype = Bug AND fixVersion IN ("Release 1", "Release 2", "Release 3") AND status NOT IN (done, closed, canceled)

 See more on how operators work on this page!

Ste