We use Jira and Сonfluence cloud license.
I need to prepare a table in Сonfluence for Managers:
Label, Task name, Task description, Task number.
Is it possible to somehow add just the task number from Jira, and the rest of the fields so that the other fields are added automatically?
Hi @Iya Belyaeva ,
It sounds like you are looking for the features in the Jira Issue macro, that will display a data set with a customized set of columns from your live Jira data set, based on a saved filter.
Check out the Documentation on the gadget at the following link, and let me know if this is what you are looking for:
Hi @Iya Belyaeva ,
Glad it helped out, but for the follow up portion your confluence users (top managers) that do not have access to the Jira data, they will not be able to see the content in the macro. The Jira issue macro is going to only display content based on the viewers permission set on the Jira side of the application link so they would also need permissions in Jira to see this report.
If you are looking for a sharable report to non jira users in a confluence page a really good workaround for this comes with the new "Jira Cloud for Sheets" add-on which is free add-on for google sheets we released recently.
With this add-on you can set up a sheet to pull in live data from jira under your user account, and manipulate the data as desired for your reporting purposes using all the capabilities of google sheets, then generate a shareable link from the report in sheets to make a viewable copy of the static data in the sheet, then using that sharable link you can embed the sheet into a iFrame macro on the confluence page and anyone looking at the confluence page will see a read only version of the report hosted on google sheets.
It would look something like the following exe in your confluence page:
Some pro tips for your use case would be to:
Alternatively, there is not a native built in option to create a sharable external report for users that are not authenticated to the corresponding Jira application, so it would require manual report generation for the non authenticated users and manual input to the page for viewing
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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