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. 

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Yvette Nash 

The syntax of the formula should be different - you need to specify to which linked issue the status category-based filtering applies:

issueLinks.FILTER($.type = "risks" and $.source.status.Category != "done") 
you might need to change source to destination depending on the link direction.


I hope this helps. If you're on Jira Data Center or Jira Cloud, please reach out to us directly at our  support portal if have more questions about Structure.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Yvette Nash]

destination worked! Thank you so much.

And thank you for the portal link. Most of my questions are around structure.

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

[Vitalii Rybka]

Sounds strange.

Did you try to check what returns issueLinks.FILTER()?

As far as I understand, issueLinks returns link objects, not issue objects directly.