How to write JQL to list issues based on specific text in cascading field values

[Murthy A M]

Hello All,

I am looking for syntax to list all issues where a keyword matches with the value of the cascading select field.

Example:

I have a cascading select field with values such as ;

Parent Value -> Child values

Car -> Maruthi(4seater)

Car -> Ford(4seater)

Car -> Maruthi(7seater)

Car -> Ford(7seater)

I am looking to list all issues which contain keyword "4seater" in child value of the cascading field.

I did not find much help on syntax in this article: https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html#Advancedsearching-functionsreference-cascadeOptioncascadeOption()

OR in a simple way, I want to be able to write a JQL query that returns all issues where the selected value in that custom field contains a particular string.

For example, if the possible selectable values in a field are:

A111, A222, A333, B111, B222, B333

...I want to create a query that returns all issues where the selected value in that field contains the letter A. So it will return all issues where the selected value is A111 or A222 or A333. But it will not return issues where the selected value is B111, B222 or B333.

Regards,

Murthy

[John Funk]

Hi Murthy - Welcome to the Atlassian Community!

Try this:

Parent = Car and Parent in (Maruthi(4seater), Ford(4seater))

You actually use the name of the cascading field both times - I know it is weird, but it works. 

[Murthy A M]

Hi @John Funk 

Problem is I have closed to 250 values in the cascading field, but the values in child are concatenated with values such as (4seater), (7seater) etc., these kind of values are only about 5 to 6 values. Hence, I would like to query based on only those values.

I want to be able to create a JQL query that returns all issues where the selected value in that custom field contains a particular string.

For example, if the possible selectable values in a field are:

A111, A222, A333, B111, B222, B333

...I want to create a query that returns all issues where the selected value in that field contains the letter A. So it will return all issues where the selected value is A111 or A222 or A333. But it will not return issues where the selected value is B111, B222 or B333.

[John Funk]

Not sure you are going to be able to do that since cascading fields cannot use the ~