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.