How to create a table with automatically filling data: Label, Summary, Description, Task Jira Numder

[Iya Belyaeva]

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?

[Earl McCutcheon · Accepted solution]

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:

• Jira Issues Macro

Regards,
Earl

[Iya Belyaeva]

Hi @Earl McCutcheon 

Yes, thank you very much, this is what I need!

Another question: if our top managers don't have access to the Jira, but have access to Confluence, can they see this table displayed on the Confluence page through this macro?

[Earl McCutcheon]

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:

• For dynamic live data:
  • set up a main page to import the data using the =jira() command on sheet1
  • do some static inputs on sheet2 (like project name or time periods) that will be referenced cells in the =jira() command on sheet1,
  • then set up sheet3 to populate a dynamic report pulling data from the main data set of sheet1
  • This way the sheet1 data will dynamically update any time you provide new inputs on sheet2, and then sheet3 calculations for the report will base of the updated data pull
• For a Static view of a period of time just do a single sheet Import the data as a one off import using the sidebar import in lieu of the =jira() command and then manipulate as needed for a snapshot view report of the data

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

Regards,
Earl

[Iya Belyaeva · Accepted solution]

@Earl McCutcheon  thanks a lot!