Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL for drop down values

Devi Vaishnavie December 8, 2022

How to pull data from drop down values (Customized field) in jira via JQL. For instance, if I have a dependent dropdown as follows:

 

Option 1

  Value a

  Value b

  Value c

Option 2

 Value a

  Value b

  Value c

How could I view tickets mapped against Option1 -->Value b and Option2 --> Value c. Can anyone help me with JQL ?

 

 

 

1 answer

1 accepted

1 vote
Answer accepted
Matthias Gaiser _K15t_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 8, 2022

Hi @Devi Vaishnavie

I'm not exactly sure what you mean with "dependent dropdowns". Could you elaborate on that or maybe include a screenshot?

In general, a JQL for two dropdown values would be:

"Single Select 1[Dropdown]" = B AND "Single Select 2[Dropdown]" = C

Does this help?

Cheers,
Matthias.

Matthias Gaiser _K15t_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 8, 2022

If you're talking about the cascading select fields, I'd recommend a JQL like this:

"Cascading Select" in cascadeOption("1","b") or "Cascading Select" in cascadeOption("2","c")

More details about cascadeOption can be found in the docs.

Like # people like this

Suggest an answer

Log in or Sign up to answer