JQL query using cascadeOption

[Charles Delaporte]

Hi,

I have create a field using the Cascade Option. This field does not have a default value. I would like to create a JQL query to select issues for which this field is blank. I managed to create the JQL query to find issues for which this field is in a specific list (e.g.   ..... in cascadeOption(10604)) but I struggle to search for blank values. 

Could you please tell me how to write this query?

[Rambabu Patina _Appfire_ · Accepted solution]

Hi @Charles Delaporte,

The keyword "none" can be used to search for issues where either or both of the options have no value. For example:

location in cascadeOption(none)

For reference see Advanced searching function cascadeOption

Thanks,
Ram.

[Charles Delaporte]

Thanks!

[Gabriel Viger]

Hi Charles,

You will find your answer here:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

Cheers,

Gabriel