Search for Epics belonging to a specific set of criteria, and associated Stories

[Martin Denham]

Is it possible to search for all epics in a specific project, and also return associated stories (regardless of which project they may be in)...

For example...

• Epic CISMDS-12345
  • Story CISMDS-12346
  • Story CISOPS-3245
  • Story CISIDEL-3524
• Epic CISMDS-12389
  • Story CISIDEL-3534
  • Story CISDCOL-1276

 CISMDS, CISOPS, CISIDEL and CISDCOL are all different projects.

JQL would be something like "project = CISMDS and (issuetype = Epic OR (issuetype = Story and ***is linked to any of the epics in the project***))

This should return 7 records (2 Epics and 5 Stories)

[Shaili_RVS_Support]

Hi @Martin Denham 

If you would be interested in a readymade solution, you can also look at our plugin to get this data

Agile Tools : Epic Tree & Time in Status 

The app provides 5 important features, as below to track time and manage issue hierarchies

• Epic Hierarchy :- View/Manage roll up for standard Jira hierarchy. Epic -> User Story -> Subtask
• Links Hierarchy :- View/Manage roll up for hierarchy (up to 10 levels), based on your Issue Links parent child relationship
• Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features
• Timesheet :- View/Enter your time spent for multiple days
• Time in Status :- More than 7 types of Time in Status reports to track your issues.

[Daniel Turczanski - JQL Search Extensions]

Hi @Martin Denham ,

With standard JQL you can only get a list of epics in the project and then run another search for all issues with the epic links returned by the first query. This only works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

• JQL Search Extensions

After you install the app you can simply search:
issue in childrenOfEpicsInQuery("project=CISMDS") or (project=CISMDSand type=EPIC)

Make sure to have a look at the documentation.

I hope this helps!
Daniel