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 _Tempo_]

@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") 

[Christos Markoulatos]

Hi @Yvette Nash  what I believe is happening:

1. In Expr, the status category is accessed as a nested property: status.category (not statusCategory).

Solved: Need help with Structure for Jira Expr advanced ex...

1. issueLinks iterates link objects ($.type, $.source, $.destination). To filter by the linked issue’s fields (like status or issue type), you must look at $.source/$.destination first.

Sample Formulas - Issue Links and Subtasks

Try the below and let me know if it worked for u:

WITH linked = issueLinks.MAP(
IF($.source = this, $.destination, $.source)
) :
linked.FILTER($.issuetype = "Risk" AND $.status.category != "Done")

• issuetype is the issue type name (make sure it’s exactly "Risk").
• status.category will be "To Do", "In Progress", or "Done"; using != "Done" keeps only open items.

Hope this helps 😊