Running into Issues with JQL in Data Center and

[Brian Taylor]

I have the following query that has a custom field that is a cascading field with a level 1 value of KTLO and a secondary value. I am looking for any issues where the secondary value is not set.  

issuetype in (bug, Incident) and cf[14200] in cascadeOption("KTLO", none) and status != Cancelled

It never returns any issues where the secondary value is not set.  

[Fabio Racobaldo _Catworkx_ · Accepted solution]

Hey @Brian Taylor ,

based on documentation it should work https://confluence.atlassian.com/jiracoreserver/advanced-searching-functions-reference-939937722.html#Advancedsearchingfunctionsreference-cascadeOptioncascadeOption()

My suggestion is to raise a ticket to atlassian support.

Fabio