How do I show ALL the stories under the parent epic of a story that meets my criteria?

Question

Hi folks. I'm looking for a query that will return all stories of an epic when only 1 story meets my criteria.  For example, I want to group all epics and children with stories that have a FixVersion with a title containing 2019.  My current query only returns the 1 story with the FixVersion of 08-2019 and the parent epic. I want to see all of the stories under that epic so I have the complete picture.  I don't care if I have duplicates. I'm using Jira Structure and feel like I'm so close. thanks for any help you can provide.

I currently see:

Grouped by FixVersion - 08-2019

Epic 1

Story 3 - 08-2019

Epic 2

Story 7 - 08-2019

Grouped by FixVersion - 09-2019

Epic 1

Story 4 - 09-2019

I want to see:

Grouped by FixVersion - 08-2019

Epic 1

Story 1 - no fix version

Story 2 - no fix version

Story 3 - 08-2019

Story 4 - 09-2019

Epic 2

Story 5 - no fix version

Story 6 - no fix version

Story 7 - 08-2019

Grouped by FixVersion - 09-2019

Epic 1

Story 1 - no fix version

Story 2 - no fix version

Story 3 - 08-2019

Story 4 - 09-2019

Epic 3

Story 11 - no fix version

Story 12 - no fix version

Story 13 - 08-2019

Nikki Bridwell · Answer

I’m already getting my story which will bring in my epic. That part works. I just need the piece that brings in the additional stories under that epic along with the story ready for release in that fixed version. Those stories may have no or future fix version. I still want to see them.

Muhammad Ramzan_Atlassian Certified Master_ · Answer

if you don't associate the epic with fixversion then you can only get those stories which have fix version.

Problem is , you have queries which don't have the fixed version but you are trying to get them under a fix version group , it will not work. you need at least one link for fix version either with story or at parent level with epic

Nikki Bridwell · Answer

Thanks for the suggestion. The reason I need the query is because our organization does not require the epic to have a fixversion and this out of my control. The story will always have the fix version. I want to see the whole picture as our teams are still maturing.  Ideally we’d plan the epics upfront, but that’s not our current state.

I haven’t tried building a sub-query/filter to return stories with fixversion to see if that would give me everything I need. Any thoughts there?