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

Your Points Tracker
Challenges
Leaderboard
  • 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
Recognition
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?
Kudos
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:

Regards,
Earl

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

Regards,
Earl

Like Iya Belyaeva likes this
0 votes
Answer accepted

@Earl McCutcheon  thanks a lot!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

⚡️NEW Group for Confluence Cloud Admins

Calling all Confluence Cloud Admins!  We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...

107 views 2 9
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