JQL for drop down values

[Devi Vaishnavie]

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 ?

[Matthias Gaiser _K15t_ · Accepted solution]

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_]

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.