Structure with Theme and Epics that are not Closed

[Amy Jensen]

I'm trying to create a query to build a structure that returns a Theme at the top level, with all Open child Epics.  

Here's what I have currently
issueFunction in portfolioParentsOf("issuetype = Epic and program = xxx and status != Closed") and issuetype = Theme

This returns all Themes where there is at least one open epic and lists all epics (open and closed)  I understand why that is happening, but I can't figure out the correct query to return only the open children.  

This is what it looks like:

• Theme 1
  • Epic A
  • Epic B (Closed)
  • Epic C
• Theme 2
  • Epic A (Closed)
  • Epic B

This is what I want it to look like:

• Theme 1
  • Epic A
  • Epic C
• Theme 2
  
  • Epic B

Thanks in advance for any suggestions.  I tried a few nested queries but saw the same results.  

[Amy Jensen · Accepted solution]

I just found the Filter Generator and that solved it.  

[Yulia Barbash _ALM Works_]

Hello @Amy Jensen !

Yulia from ALM Works here!

I'm glad that you were able to find the solution.

In case you have any other questions, do not hesitate to reach out to our support team via support@almworks.com.

Best regards
Yulia Barbash