Creating a Jira structure formula to find the array of open issue types

Yvette Nash

Hello!

I have a structure formula column where I want to show an array of open issues of a certain type. We have a custom issue type called Risk. When I use the following formula I get all the linked issues of type Risk

issueLinks.FILTER($.type = "Risks")

Great so far.

Now I want only the ones that are in some state of openness.

issueLinks.FILTER($.type = "Risks" AND $.statusCategory != "Done")

I get back the exact same list even though some are closed.

I get the results I want in basic JQL search filters but can't seem to figure out the correct syntax for structure formulas. 

Stepan Kholodov

@Yvette Nash Hello again,

just in case anyone else finds this post: please refer to the answer from its duplicate here: https://community.atlassian.com/forums/App-Central-questions/Re-Creating-a-Structure-formula-column-that-lists-issues/qaq-p/3111671/comment-id/20046#M20046

the correct syntax is: issueLinks.FILTER($.type = "risks" and $.source.status.Category != "done")