Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

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

0 votes
Answer accepted

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

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
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

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...

326 views 9 7
Read article

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