Simple query for Capability linked to Portfolio Epic?

[Larry Boyd]

Want to execute a query showing the below:

Portfolio Epic; Capability (multiple linked issues); Epic (linked issue to Capability) and User Stories (linked to Epic)

There are multiple Portfolio Epics (PE) assigned to the Program Increment.  Each PE contains at least one Capability and each Capability contains at least one Epic.  Lastly, each Epic contains at least one User Story board.

[Kit Friend]

Hey @Larry Boyd are you using Advanced Roadmaps/Plans or another plugin to create the parent/child hierarchy here + do you have any other plugins (e.g. Scriptrunner) available in your instance?

Some starters to think around here: https://confluence.atlassian.com/advancedroadmapscloud/searching-for-issues-using-advanced-roadmaps-details-998651411.html - 

• issuekey in portfolioChildIssuesOf("INIT-001")
  
  

^ this one might do you