You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am trying to create a JQL query, where I test the value in a field that is populated from a pull-down menu.
The value is a "NR1" or "NR2" and the name of the field is "Network Release Fixed".
I have tried "Network Release Fixed" = "NR2" but that yields no results but I do have records with NR2 selected for the field.
I have also tried
My query is "Network Release Fixed[Dropdown]" = "NR2" but I get the error message: "Field 'Network Release Fixed[Dropdown]' does not exist or you do not have permission to view it."
What could be my problem?
@Alistair Jones I'm guessing that you have a multi-select list which may be causing the issues. Instead of = I would recommend "in". So your JQL would look like this:
Network Release Fixed in (NR2)
If this doesn't work, there's a good chance the option NR2 has a space before or after the text. You may need to confirm with your admins as it can be difficult to identify from looking at an issue.
Are you certain you have the field name correct? Below is an example of a single-select field returning the same results with "=" and "in". When using the "in" function, parentheses are required.
Note: Quotes are only truly needed when the field or option has a space such as Network Release Fixed to avoid Jira from viewing these as three separate fields. NR2 doesn't have spaces so quotes aren't required.
Are you getting any errors with "Network Release Fixed" in (NR2)? Or just no results?
Can you share a screenshot of an issue where you see "Network Release Fixed" is set to NR2?
I posted some screen shots. I don't think I have spaces or special characters but I inquired of the JIRA administrator just to make sure.
I do agree that if I am not matching with the "NR2" string, this would be the reason for no results.
So, while I await an answer from the administrator, I am conducting my due dilligence.