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?
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?
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")))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Let me know the results! I'm curious to see if that worked. :-D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This appears to work! Looks like it does everything I wanted to get accomplished!
You are a legend! Thanks for all the help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Awesome! I'm glad we figured it out. I'd appreciate it, if you marked it as answer. Have a great day!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.