I would like to get an array with all my epics and in one column to get the stories that have that epic.
I am looking for the same kind of display that I can get with Link for example when I link 2 stories.
Epic Link is going the over way around, Link does not show the user stories.
Just to clarify, the output would be
on the line, the epic name and the columns would be the story status, like Opne, in progress, Done.
Then each column would contain the number of stories that are in that status.
Thanks for any help.
@Noah Hofmann - please take a look at the following and my responses on this thread. It should help.
We can recommend you our Table Filter and Charts for Confluence app to work with Jira Issues macro in your cases.
You'll be able make pivots to count, for eхample, the numbers of issue types and display issues per assignee (or user stories per epics), also sort your issues on the fly like in Excel, save the required filters for other users and even transform and visualize data.
Here are some examples of dashboards created using the Jira Issues macro and the Table Filter and Charts for Confluence app.
If your Confluence instance is Cloud, you'll need the Table Toolbox macro to nest other macros. Other steps are the same.
Ok, someone from Atlassian, PLEASE, try your best to either provide a yes or no answer, to the above thread or this response. Since we are all in IT, I have summarized the questions/requests below to make it easier. I have added a simple YES or NO option.
Please respond with either because it can't be both.
So, is it YES or NO?
NOTE: Attached is a visual representation because it seems that typed questions/requests are not being received very well. I even added a numbered list (1., 2., 3.) so you couldn't get lost.
1. Go to the advanced search in your JIRA Project with the epic
2. click on "+ more"
3. check the entry "Epic Link"
4. search for the epic(s) you want to have in your conlunce table
5. once you configured the filter as you want, copy the link of the address bar
6. go to your confluence page
7. Insert Jira issue/filter
8. paste the link in the box
9. display options: configure the the table as you want
Hi @Peter Tresenreiter thanks for your answer, however, it seems like you didn't get what we are looking for.
I'm looking to build the table which will show me all my epics for the project with the breakdown to user stories that belong to each epic and ideally their status.
I can't put the table to this comment, so something like that:
Epic is the first column, linked user stories are in the second column.
I figured out a work-around that may work for you. It works for me and I was looking for a similar setup.
When using the "Insert JIRA Issue/Filter" tool in Confluence, use Search and type in: "key = ecom-167 OR parent = ecom-167".
NOTE: ecom-167 is the Epic and this will pull in the epic as well as all child tasks.
the proposed one did not work for me, but this filter did:
"Epic Link" = [insert JIRA Epic number here]
it seems it depends on the individual jira configuration, so just check with your admin, which parameter could be used. the filter basically just uses the filter that is used for issue search in order to create lists matching a certain criteria.
@Amurafa - yes, so I can pull all related "issues" within an epic using a similar query ("Epic Link" = xxxxx ORDER BY issuetype DESC).
But everyone on the thread is looking for a solution that will nest stories within their own confluence page under parent epic page. Something similar to the attached snapshot. A query that pulls an epic's related "issues" is simple & elementary but we are all looking for a next level solution.
Also, when querying an epic which lists issue on the same page, users are unable to edit those stories directly in confluence, if you try to edit a story within confluence, you are redirected to JIRA but this is probably a separate topic.
@Michael Ludvigson - you may want to try some of the queries listed in this thread, I went thru the thread and found a few that may work, included my own. Hope this helps!
@Anthony Coleman thank you very much for the assistance. tried all of those and its just not pulling the info like we need. we're using cloud version, not server, and I'm wondering if that might be part of the issue. looks like you nailed it when you said you wanted them nested, that's what we're looking for too.
@Michael Ludvigson - unfortunately it does not seem possible unless Atlassian provides custom code & query in a new macro.
But as I mentioned above, this only solves half the problem because even if it was possible nest stories on their own pages in confluence within an epic hierarchy, it most likely would just be a link to the story "issue" and the fields within the story "issue" would not be editable. The ability to edit an epic or stories fields within confluence and have the changes sync'ed to JIRA, would truly be a next level solution, . It's surprising the Atlassian hasn't made this ability native to their products because both confluence & JIRA are complimentary of each other. I will keep searching for a solution and will post here if I ever discover the magic key. Thanks!
@Michael Ludvigson - I might have found a work-around for the 2nd problem, editing stories "issues" in confluence. Check out this plug-in on the marketplace: Issue Manager for Confluence | Atlassian Marketplace (https://marketplace.atlassian.com/apps/1216691/issue-manager-for-confluence?hosting=server&tab=overview)
It allows for creating & editing 'issues' within confluence and sync'ing to JIRA. It looks pretty nice but it only supports editing the following list of fields:
This question was asked back in 2014. Has anyone in Atlassian looked into this? If the functionality is not available please let me know. I also looked into exporting our backlog data to then copy and paste into a Confluence report so that I can display Epic Name and Story together, no joy here either. Without the Epic name our sprint/issues are meaningless to Senior Management.
1. Create advanced filter in Jira
"Epic Link" = Name of Epic
* Name of Epic will probably change to an ID automatically, nothing to worry about.
2. Insert Jira issue/filter macro to a confluence page using
filter = "Name of Epic"
2.b Set display option to Table.
Maybe this link below have additional information which you are looking for:
If you need more information, please let me know.
All the best,
Thanks, I also reviewed that page and it is describing how to create a link between an epic and a confluence page. What I am looking for is how to add to a confluence page a Jira report that would contains all the epics and in each epic row the list of user stories that are connected to the epic, the same way you can list jira stories and their linked stories.
I was trying to solve the same issue today. Jira doesn't provide an out-of-box solution.
It can be achieved with Structure addon.
It will show you all of the issues under an epic, which you can further filter out by JQL.
The plugin provides several views. One of them is Tracking. It shows a percentage of completion for each epic, based on the issues that are linked to that epic.
dLaurendeau, I also am trying to do this in Confluence server.
When you refer to "structure", do you mean you were able do incorporate the output of multiple epics with nested stories/features in one go, or did you have to do it per epic? If the former, I would love to lean how you did it!
Yes, in the hosted version I could create a list of all Features (or a subset if I didn't want to see all - in the hosted version we have Features that are equivalent to cloud epics). A structure is a container that could hold Features. There was a down arrow available and I could expand one or more Features and see all the stories underneath them. I could choose the columns that would show across the screen. I am now on Jira Cloud at my current gig and there are no Structures available.
I can use a query in Confluence with "parentepic" and I can get multiple epics and all of their associated stories but the stories don't nest under the epics. The alternative is to create multiple "parentepic" queries on a single Confluence page. It works, you can get an epic with all the associated stories nested under it but each query will have a different width for the same column and the Confluence page looks messy. That said, it does work.
I have the same need, display the epic name, issue name in a single list. Only thing that seem to be appearing is the issue link and it is just displaying the epic key. I would like to pull the epic name on to the report. I find JQL working while executing from JIRA, it is just that confluence is not displaying it.
Please review our documentation below regarding JIRA agile and Confluence integration:
I hope the mentioned feature above fulfill your requirement on this.
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
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