Creating a Structure formula column that lists issues of a custom issue type

[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. 

[Vitalii Rybka]

Hi @Yvette Nash,

The issue you're facing is probably because of how Structure formulas handle the statusCategory property. In Structure formulas, you have to access the status category differently from JQL.

Here are a few approaches to try:

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

2. issueLinks.FILTER($.type = "Risks" AND $.status.statusCategory.key != "done")

If that doesn't work, try to use the resolution field:

issueLinks.FILTER($.type = "Risks" AND $.resolution = null) 

The key difference from JQL is that Structure formulas require you to navigate the object hierarchy explicitly (e.g., $.status.statusCategory.name instead of just $.statusCategory).

[Yvette Nash]

Unfortunately, none of these worked.

There is also some very odd behavior I notice. Regardless of what I use after the AND operation, if it's a != operation, I get the whole list while if I use an = operation, the array is empty. NOTE: my test epic has multiple linked Risks, one is open and one is closed. I'm either getting the whole list or nothing at all.