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

Help with Jira Query Language filters not filtering the way I want them to

ryan.johnson

JIRA filter question that hopefully someone can answer for me:

project = RLCN AND resolution = Unresolved AND (affectedVersion = "RL China - Dec Content" OR fixVersion = "RL China - Dec Content") AND (fixVersion != "RL China - z 2019 Backlog") AND (fixVersion != "RL China - OB1") AND (fixVersion != "RL China - OB2") ORDER BY created DESC

This filter seems to only show bugs that have affectedversion AND fixversion as Dec Content. If a bug only has affectedversion as Dec Content, but has fixversion set to None, it won't show up.

Does anyone have any idea what's wrong with the syntax here?

Accepted answers

edwin vasquez_f9df79

Do you need to specify that the fixversion is "RL China - Dec Content" ?

Maybe we should start with, what are are the search results you need?

All comments

edwin vasquez_f9df79

Do you need to specify that the fixversion is "RL China - Dec Content" ?

Maybe we should start with, what are are the search results you need?

edwin vasquez_f9df79

If you care mostly about the issues in the affected version, then try the query below. If not, let me know what is the goal you are trying to achieve with the query.

project = RLCN AND resolution = Unresolved AND ((AffectedVersion = "RL China - Dec Content") and (fixversion not in ("RL China - z 2019 Backlog","RL China - OB1","RL China - OB2")))

Jack Brickey

The way it is written, yes the results will not include issues w/ FV empty.

If you want something to show up when the FV is empty then you should add "...OR fixversion is Empty...". This is often forgotten when constructing JQLs.

ryan.johnson

That is definitely a cleaner way to filter out the fixversion!

However, I also want this filter to display bugs from an older affectedversion that was punted to this fixversion.

For example, if a bug has affectedversion Oct Content, but it has its fixversion changed to Dec Content, I want it to show here as well.

This filter is intended to show all bugs that are being worked on for the Dec Content release, whether they were originally found on this release or an older one.

ryan.johnson

Could you explain to me why this is though?

I thought the (affectedVersion = "RL China - Dec Content" OR fixVersion = "RL China - Dec Content") would mean that if the bug has affectedversion Dec Content or fixversion Dec Content it would be included in the filter results. So a bug with affectedversion Dec Content should show up even if fixversion is set to None?

edwin vasquez_f9df79

Give this a try

project = RLCN AND resolution = Unresolved AND ((AffectedVersion = "RL China - Dec Content") and (fixversion not in ("RL China - z 2019 Backlog","RL China - OB1","RL China - OB2")) or fixversion = "RL China - Dec Content")

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql