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

[Nikki Bridwell]

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

[Muhammad Ramzan_Atlassian Certified Master_]

you are grouping with fix version, how you can get those stories which have no fix version.

If your epics  have fix version then you can get all stories using following query either they have fix version or not

issue in allIssuesInEpic("fixVersion =yourversionid")

This query is part of the plugin  JQL Search Extensions for Jira & reports  

[Nikki Bridwell]

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? 

[Muhammad Ramzan_Atlassian Certified Master_]

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]

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.