Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
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

Creating a table in Confluence pulling in JIRA information

I am looking for a way to pull in JIRA story information to a table into Confluence.

 

I have a table with 7 colums -

JIRA Defect - I can pull in the JIRA Story and it will show real time if it is open, closed, bug, story, etc

Issue -

Description -

Blocker -

Status -

Date Created -

Date Closed -

 

Is there a way to pull the column information from JIRA so it will update realtime?

1 answer

0 votes

Hello Natalie,

What you are describing is very similar to the functionality of JIRA Issues Macro. This will update in real-time, and you can use a specific filter to display results. Additionally, you can specify which columns to display, and in which order.

Perhaps this will work for your needs? If not, please tell us how your requirement differs from what is offered by the macro and we can try to come up with an alternative solution for you.

Kind Regards,
Shannon

Hi Shannon,

 

Thank you for the respone, this did help!! I am now running into a different issue.

 

When I am on the macros - insert JIRA/Issue Filter. I want to search for JIRA issues. If all of my stories are under SDU-###, I would think I could just search SDU and they would all come up, that is not the case. I have to type in every JIRA issue number that I want to add to the macros. That is very tedious. Is there another way to search for issues using this?

Hi Natalie,

Thank you for letting us know that it fits your needs!

For your new problem, I would suggest raising a new question, that way our community will all see it. I'm not quite sure what causes that so once you raise the new question the community will be able to assist you.

Let me know if you have any trouble doing that.

Kind Regards,
Shannon

Hi Natalie,

I think you need to type JQL "project = SDU" instead of typing each issue separately.

Andrey,

Thank you for the respones! Soo it partially works, I type in:

 project = SDU

The first 20 items show up there is no way for me to see any other items. If I click "View All" it takes me to JIRA and I get an error.

Do you know if there is a way to search by Version or Epic (that is what I really need). Maybe I am doing the JQL wrong? ahhh I don't know!

To show more than 20 issue you need to increase Maximum issues limit. 

You can read more about this macro here.

For version JQL will look like fixVersion = "2.0".

 

But the easisest way to get correct JQL is to go to Issue Navigator in JIRA, set filters you want by selecting projects and versions, then switch to Advanced search mode (link in the right side) and copy JQL to your JIRA Issues macro.

Thank you!! That was very helpful exactly what I needed :)

Hi - using this is Jira server - All I get then I pull the query in is a table  inserted in the page within one cell of the table.  I want a table which I can import the jira items in it that I can then add other information manually against in other colums is this possible?

Suggest an answer

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

Miss the Confluence demos at Team 21? Watch them here!

Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...

282 views 2 6
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