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

I just found the Filter Generator and that solved it.