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.

[Martin Runge]

Hi,

By default, standard JQL and the Jira Issues Macro in Confluence cannot display multi-level link hierarchies (Initiatives ➔ Epics ➔ Stories ➔ Confluence Pages) mapped side by side in structured rows. JQL filters always output flat lists, and standard Jira macros cannot trace and align recursive "Mentioned in" Confluence links dynamically into a matrix.

I could think of two ideas to solve this requirement:

• If you have Jira Premium, you can use Plans (Advanced Roadmaps) to track this hierarchy and also display it in Confluence.
• To get the exact row-by-row mapping of Jira hierarchies alongside their Confluence documentation, a marketplace app like Structure or Snapshots of Jira Data into Confluence could help here.