Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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? 

2 answers

1 accepted

1 vote
Answer accepted
edwin vasquez Community Leader Dec 04, 2019

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 Community Leader Dec 04, 2019

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

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 Community Leader Dec 04, 2019

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

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 Community Leader Dec 06, 2019

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

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 Community Leader Dec 08, 2019

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 Community Leader Dec 08, 2019

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

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 Community Leader Dec 09, 2019

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

Done! Thank you!

1 vote
Jack Community Leader Dec 04, 2019

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.

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?

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you