Parent->child->grand children- displaying on boards and reporting

[corky cork]

how do I report on: 

Parent tickets-> child tickets->grandchildren of child tickets in different projects.

There are hundreds of issues. 

Parent and child tickets are in one project. Grandchildren tickets are in other projects.

I have 3 queries: 1. Parents 2. children 3. grandchildren but how do I link the children with the grand children and then link the parents with the children so I can see:

1. Parent ticket column 1 . Children tickets in column 2 . 3. grand children tickets in column 3 which relate to the children tickets

Each child ticket can have many grandchildren

Context of data: Parent: Instructional document

Child: tickets representing each task of the instructional document

Grand children: dev tickets relating to each child task

thanks

[Ivan Manolov - JXL]

Hello @corky cork 

Welcome to the community.

As mentioned by @Ekaterina Smykova , Advanced Roadmaps offers such a functionality and it is available as part of Jira Premium and Jira Enterprise.
If you you'd like to stay on the Jira Standard plan and are open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a number of advanced features, including support for (configurable) issue hierarchies. These issue hierarchies can be based on Jira's built-in parent/child relationships (like task/sub-task, or epic/story), and based on issue links of configurable issue link types. It does not matter if the issues come from one or hundreds of projects. You are able to connect and visualise them in a tree structure.

This is how this looks in action:

 

In this example, I've created another issue type above epic level, created the relevant issues, and connected them via issue links. I've then modelled this hierarchy in a custom structure in JXL, and voila. This works for all Jira plans, including the Standard plan.

Any questions just let me know,

Best,

Ivan

[Ekaterina Smykova]

Hello @corky cork ,

Welcome to Community! :)

Which type of linking you use among all parents-children? If this is "Parent Link", which comes from "Plans"(Advanced Roadmaps), you can use the functionality of the plugin. 

Can this be a solution for you?

Regards,

Katja