It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Roll-up reporting for Initiatives Edited

Hi all, I am trying to create a jql query that I can use in Confluence to report on progress with an initiative.

Has anyone else tried this sort of thing? If so, did you have any luck with it?

Outcome required:

List stories that belong to all epics that are linked to an initiative.

Objective:

Want to enable roll-up reporting. For that to happen we need to see a list of the Jira Child stories for all Epics that are linked to an Initiative story.

Background:

The (INI) initiative is a kind of story that allows analysis, review, validation, sizing, etc, of new initiatives (projects). As early refinement on the initiative progresses Epics begin to emerge that capture the requirements as features or capabilities. These Epics and their stories form the basis for sprint backlogs that will deliver the implementation of the initiative.

Following are some queries I ran and my edited results.

+++++++++++++++++++++++++++++++++++++++++++++++++++++
Query: issuetype = Epic AND issue in linkedIssues(INI-97)
Returns: "success" - A list of epics that are 'linked' to the identified issue
Result:
--------------------------------
Sprint Assignee T Key Sub-Tasks Summary Story Points Status Resolution Epic Link Days since last comment Last Documented Status
Unassigned Epic TEST-1645 Backoffice Implementation OPEN Unresolved 15 weeks ago
Unassigned Epic DEMO-681 Gateway Implementation OPEN Unresolved 15 weeks, 6 days ago
--------------------------------

+++++++++++++++++++++++++++++++++++++++++++++++++++++
Query: "Epic Link" = TEST-1645
Returns: "success" - A list of stories created to implement the requirements captured by the Epic.
Result:
--------------------------------
Sprint Assignee T Key Summary Story Points Status Resolution Epic Link
Team1-S17-0920 Ash Story TEST-1676 This is another test 1 DONE Done Compliance: Stored Cards
Team1-S17-1004 Louise Story TEST-1677 SPIKE: This is a test too? 1 DONE Done Compliance: Stored Cards
Team1-S17-1115 James Story TEST-1659 SPIKE: More test stories 1 UNDER INVESTIGATION Unresolved Compliance: Stored Cards
Team1-S17-1115 Andrew Story TEST-1687 This is a test story 3 IN PROGRESS Unresolved Compliance: Stored Cards
--------------------------------

I appreciate any thoughts any of you may have to contribute to this issue.

1 answer

Did you ever get anywhere with this?

No

I tried a few things with Perl too but just didn’t have the time to work this through. I’d be happy to work with anyone else on the problem. If anyone reading this wants to try to crack this nut please reply so we can discuss 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

303 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you