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
Next: Root
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.
Thanks for your reply, Mathew. None of the following works:
"Network Release Fixed" in "NR2" - with or without quotes around NR2
"Network Release Fixed" in (NR2) - with or without quotes around NR2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mathew,
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.
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.