nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Stepan Kholodov

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)

All comments

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:

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

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.

Stepan Kholodov

Yvette Nash

destination worked! Thank you so much.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

structure

formula