nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does JQL produce searches for values from a dropdown custom field

Jean Ann Harrison_skp9mu

I've been trying to search issues based on a customized field which I created along with specific values from a dropdown type. When I write a query specifying a value within the dropdown options available, I get an error: "The option for the field does not exist" yet I know that value does exist since I created that custom field with the options.

I have tried to create more than one query based on dropdown values for more than one custom field and have not been having any luck going beyond the error. As such, it has started to make me wonder if it's possible although I would think, that indeed I should be able to search issues based on a custom value for any field despite the type of that field's value options.

An example of my query: Project = "<project name>" AND "<custom field name>" = "<option within the dropdown>"

Any thoughts? Thank you in advance for any advice.

Accepted answers

Trudy P Claspill

Hello @Jean Ann Harrison

Your question is posted in the Confluence Questions community, but is about creating a Jira query. Are you trying to create this query within a Jira Macro in Confluence, or are you actually working within Jira itself? (If you are working in Jira itself, then I'll move your post over to the Jira Software Questions community.)

If you are in Jira and trying to create such query, are you working in the Advanced Issue Search screen?

If you are working in Advanced Issue Search, after specifying the custom field name and entering the "=" character and then a space, the possible values for that field should display before you type anything in, similar to what I've shown below. Do you get something similar? Do you see the value you want in the list?

Screen Shot 2023-02-27 at 4.27.04 PM.png

All comments

Trudy P Claspill

Hello @Jean Ann Harrison

If you are in Jira and trying to create such query, are you working in the Advanced Issue Search screen?

Screen Shot 2023-02-27 at 4.27.04 PM.png

Jean Ann Harrison_skp9mu

Thank you Trudy for your assistance.

Yes, I'm trying to create a query in Jira and NOT in Confluence. Sorry that I entered it in the Confluence space. That was an accident.

Regarding whether I see the list of options to choose while typing my query, the answer is no, I do not see the option list while typing my JQL or any of the options I created after identifying my custom field and follows with the appropriate operator which is actually a !=.

Trudy P Claspill

Hello Jean,

It was easy for me to move your post, so no harm putting it in not quite the right community.

Is this custom field for a Team Managed project or is it a custom field created for Company Managed projects?

Can you show us an example of the field and its options within an Issue Details screen?

Was the field created very recently?

Jean Ann Harrison_skp9mu

Again, thank you.

It's a team managed project (I am a Jira admin though).

The field was created today, and I was careful to refresh my browser prior to executing the query.

Dropdown values.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

jira-software

confluence-cloud