Jira Structure - JQL to display closed issues when their

Question

Hello,

I'm trying to create a Structure with 2 different sections.

1 - This section should show all issues that are currently open, or belong to an Epic or Task that is not fully closed (at least one child ticket is still open)

2 - This section should show only closed issues or Epics and Tasks that are fully closed (all child tickets are also closed)

Are you able to assist with this JQL?

Thank you

David Niro · Answer

Hello @Rafael Tognolo ,

Perfect!

You will want to add a Group Generator to your structure and select the Attribute option.  In the Group By list, select Formula.

use this formula:

WITH ALL_ISSUES =
COUNT#subtree{issuetype}
:

WITH DONE_ISSUES =
COUNT#Subtree{
IF(statuscategory = "DONE";1
)
}:

IF issuetype = "Epic" AND ALL_ISSUES = DONE_ISSUES:
"True Closed"
ELSE:
"Open"

Basically it compares the number of issues against the number of issues that are "done" and assigns text value "True Closed" to the Epic if the two values match and "Open" if they don't.

Please let me know if it helps!

Best,
David

Rafael Tognolo · Answer

Hi David,

Ok, in this case, we're on the "on prem".

Thanks

David Niro · Answer

Hello @Rafael Tognolo ,

You are very welcome!  Thank you for the additional information!

I have an idea for this, but it is going to depend on which hosting method you are using (Cloud or On Prem).

I noticed you tagged "unknown-hosting-type".  There's a very quick way to determine this.

When you are in Structure, do you see a button for "Automation" or "Show Generators"?  If you see the former, you are "on prem" and the latter would indicate you are "cloud".

What I have in mind will work on prem, but won't yet (we're working on it) be available for cloud.

Best,
David