Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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?

2 answers

2 accepted

1 vote
Answer accepted
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Jan 07, 2020

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 @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?

Like Earl McCutcheon likes this
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Jan 08, 2020

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:

Screen Shot 2020-01-08 at 3.03.07 PM.png

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


Like Iya Belyaeva likes this
0 votes
Answer accepted

@Earl McCutcheon  thanks a lot!

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events