Need to see all issues in epic including linked issues, subtasks, tasks

[Nagarjuna Busireddypally]

I have a scenario, we are using epic, feature, technical story. Feature and technical story are standard issue types.

Features are linked with epic, technical story are linked with features using link issue functionality. Below is my requirement

1) Can we write a JQL to see the all of them that are linked to epic directly so that we can use it on dashboards

2) Is there any other way to see this hierarchy, all features should show under epic, all technical stories under features. Can we see this using bigpicture, power BI or advanced roadmaps. I need to track progress of features

Please let me know if still needed any inputs.

Thank you

[Nagarjuna Busireddypally]

I got this requirement from Bigpicture

[Rahul_RVS]

Hi @Nagarjuna Busireddypally 

If you are fine with a mktplace app to get this data, we have created an add-on to track the complete issue hierarchy across projects including linked issues.

Issue Hierarchy Reports 

Disclaimer : I am part of the team which developed this app

[Nagarjuna Busireddypally]

Hello @Rahul_RVS 

Actually i tried this trail app for my account to check if it satisfies our requirement

AMW-17 is the epic, it has AMW-19 as a child issue (Bug) and AMW-18 as linked issue(story).

AMW-18 (story) has AMW-20 as subtask and AMW-17 (epic), AMW-21 (task) as linked issues.

Below are all the screenshots, if we see the hierarchy of AMW-17 epic, AMW-21 is not showing in its hierarchy, as AMW-21 is linked to AMW-18 story, we are expecting it to show under story. Please help on this and let us know if any configuration changes needs to be made

[Rahul_RVS]

Hi @Nagarjuna Busireddypally 

Thanks for trying out our add-on.

Can we get on a zoom call to look at this. As I tried at my end and the same hierarchy works well. Ideally it should work seamlessly.

Please let me know your contact details at support@rvsoftwares.in

And I will send the zoom invite.

Thanks

[Nagarjuna Busireddypally]

@Rahul_RVS sent email as requested

[Dave Rosenlund _Trundl_]

Hi, @Nagarjuna Busireddypally.  

With respect to the other folks who answered, I'd suggest there is a way to do as you suggest, and you were (are) on the right track. There are any number of ways for you to create your own, arbitrary (as you see fit) hierarchies in Jira.

IMO you should look at Advanced Roadmaps since it comes with Jira Cloud Premium.. However, like Jira Software, Advance Roadmaps expects you to follow a prescriptive hierarchy, as @__ Jimi Wikman outlines above.

If you'd rather use your hierarchy, as you described above, you need to look beyond Jira Software and Advance Roadmaps. As you said, there are a number of Atlassian Marketplace apps like the ones you mentioned that will enable you to use hierarchies as you see fit.

Here is a search that will yield the top selling apps in this category:

Full disclosure. I work for the company that make Structure, but BigPicture is there too, and more.  Play around with the search criteria to find what you need.

Hope this helps,

-dave

[Nagarjuna Busireddypally]

Hello @Dave Rosenlund _Trundl_ Dave,

Thank you so much for your reply.

We have power BI jira connector plugin and Big picture too, could you please let us what exact configuration needs to be done to full fill my requirement.

Once again thank you so much in advance for your help on this.

Thank you

[Dave Rosenlund _Trundl_]

Hi, @Nagarjuna Busireddypally. In that case, I feel you will get the answer you seek more quickly by talking directly to the BigPicture folks at Appfire.   🙂

-dave

[mauricio.groth]

Hi @Nagarjuna Busireddypally 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your issues that are linked with epics

issue in linkedIssuesOfQuery("type = epic") 

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Nagarjuna Busireddypally]

Hello @mauricio.groth 

Actually i tried this trail app for my account to check if it satisfies our requirement

AMW-17 is the epic, it has AMW-19 as a child issue (Bug) and AMW-18 as linked issue(story).

AMW-18 (story) has AMW-20 as subtask and AMW-17 (epic), AMW-21 (task) as linked issues.

Please let me know the exact JQL function to get this data, 

[__ Jimi Wikman]

I think you have the hierarchy a bit scrambled, because the way you have it defined now a technical task is a subtask to a feature and the feature is down on story level.

If you can, then I would move the hierarchy up and rename the epic to whatever is above the Feature level. You will soon be able to rename Epic to Feature in Jira, which will make this structure easier to make.

Then you will have a proper child-parent structure with Epic⇒ Feature ⇒Technical Task⇒Subtask.

If you don't do this, then you will not be able to show the hierarchy as you describe, because Feature and Technical tasks are siblings in the hierarchy.