Building a report to find documentatiopn gaps

[Deleted user]

Hello Guru's,

We have a requirement to get the Issue links.

The Business requirements are stored as type - Initiatives

In order to realize the initiatives several EPICs have been created . The Link to the initiatives have been mentioned in the EPICs as Issue Link type - Initiatives.

Further more, there are User stories created for breaking down the EPIC into smaller requirements to realize the requirement. These user stories have Functional documentations

The User stories are further documented in Confluence with a Marco - JIRA Filter. When checked LinkType of the User Story , it is of type "Mentioned in".

Is there a way / Query that is able to extract all the Initiatives (a.k.a Business Requirements) - User Stories (a.k.a. Functional Documentation) and the Confluence documentation (a.k.a. Technical documentation) so that everything is shown in rows? 

I am trying to build this query and embed this using marco in Confluence.