How to search for a second tier value only in Cascading select field that is either empty or None

[vcatl2020]

We added a custom field having Cascade Select field type that has two tier fields - First and Second on a create screen for an issue type. We set this custom field to be required, so if any user tries creating a ticket with "None" in both tier fields then the ticket can not be created.

We noticed few tickets were created just a value in first tier field, leaving it empty/blank or "None" on the second tier field. Now we need to identify all those related tickets that are left blank or "None" intentionally. Can you please help me with a filter search syntax to find all such relevant tickets?

Note: The firs tier field could have any value but just second tier field must be either blank or None

[Trudy Claspill · Accepted solution]

Hello @vcatl2020 

Take a look at the cascadeOption() filter feature in this Altassian document.

https://confluence.atlassian.com/jiracoreserver/advanced-searching-functions-reference-939937722.html

You may need to change the version selection in the upper right to the version of JIRA Server that you are using.

[vcatl2020]

Hello!

Thanks for your prompt response with this reference link. As I couldn't find an answer in this link, so I posted my requirement here.

Basically I want to search by second tier field only without caring for first tier value. Is this possible?

[Trudy Claspill]

Oh, I see.

I think the answer on this post covers your scenario:

https://community.atlassian.com/t5/Jira-questions/How-do-I-search-the-second-value-in-a-cascading-select-field/qaq-p/59333

Or there may be an app that provides the functionality you want. 

[vcatl2020]

Sounds like only option 1 for me at the moment though there are a bunch of values in firs tier level field. :(

[Sam Greilick]

@vcatl2020 Did you ever find a solution for this? I am running into the same issue and getting the same answers in 2025