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.