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? 

[edwin vasquez · Accepted solution]

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]

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")))

[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.

[edwin vasquez]

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")

[ryan_johnson]

Didn't seem to do the trick. Bugs with affectsversion of Dec Content but fixversion of None are still not showing.

I do not understand why. I appreciate all the effort you have put into this though!

[edwin vasquez]

Last try lol

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 is Empty or fixversion = "RL China - Dec Content"))  

[ryan_johnson]

So, this filter now shows affecstversion Dec Content bugs with fixversion None.

However, it no longer displays bugs that have fixversion Dec Content but has an affecstversion that is not Dec Content.

[edwin vasquez]

See if this works

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 is Empty or fixversion = "RL China - Dec Content")) Or fixversion = "RL China - Dec Content")

[edwin vasquez]

Let me know the results! I'm curious to see if that worked. :-D

[ryan_johnson]

This appears to work! Looks like it does everything I wanted to get accomplished!

You are a legend! Thanks for all the help.

[edwin vasquez]

Awesome! I'm glad we figured it out. I'd appreciate it, if you marked it as answer. Have a great day!

[ryan_johnson]

Done! Thank you!

[Jack]

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]

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?