How to write a query in JCL for Notes entries being not null and the how to query Structure field

[eric johnson]

issuetype = EPIC AND Structure is not EMPTY - is this valid?

How to tell what is the datatype being requested? 

[Igor Sereda [ALM Works]]

Hi Eric,

I assume you're using Structure app? To query issues that are in a structure you can use structure() function:

issuetype = Epic and issue in structure('My Structure Name')

You can also use S-JQL inside structure() function to make more elaborate queries – see S-JQL documentation.

As for the Notes entries – if you mean the additional "Notes" column in Structure, it's not yet possible to query by it in JQL. As a kind of a workaround, one can sort by Notes by clicking the column header when viewing it on the Structure Board, and find the non-empty or needed values. We're working on extending this into searchable JQL function.

Hope this helps!

Igor

[Wojciech Krzyzak]

Hello Igor,
Has the feature to search by Notes column in a structure has been added yet?
What's the syntax to refer to it?

Thanks!
Wojciech

[Tuncay Senturk]

Hello Eric,

Although it is really hard to understand your question, the JQL is valid.

is NOT EMPTY means that there is an indexed value for the field. So it is not null, but can be blank string if indexed so.