Populate a confluence table with jira information

Simon B
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 7, 2024

I would like to create a table in Confluence from several Jira processes. The goal is that the editor creates individual Jira tasks and these are then automatically updated in a Confluence table. A Jira task should fill exactly one row from the table in Confluence with information.

Background: Currently, the individual data is entered individually in Jira and Confluence, i.e. once for each tool, and the automatic transfer of the data from Jira to the Confluence table is intended to avoid double entry and thus reduce the amount of work required.

What options are there to implement this?

1 answer

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Hi @Simon B ,

You may create everything in Jira and in Confluence you may just show the required data from Jira using precise JQL filters.

You may check the new Jira and older Jira Legacy macros for Confluence.

Simon B
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 15, 2024

Hi @Stiltsoft supportthank you for your answer.

For creating the table in Confluence I have used the macro "Jira Legacy". In that macro I have searched for my Jira project (key in (*project*)) and selected all the issues.

This is the table I got now (content blurried):

ji.jpg

I need to find a way that I can create columns in this table with other types of information. To give an example I need a column for the title of the issue, the responsibles and other information.

I also want to change the title for the columns. Is there any possibility to do this ?

Thanks in advance

 

Best regards

Simon

 

 

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 15, 2024

Your case is not possible out-of-the-box.

We develop the Table Filter, Charts & Spreadsheets for Confluence, which macros support the Jira Issues macro as well (that's why we didn't miss your question and its tags).

So, you may use the Table Transformer macro to rename your columns and add extra columns for manual comments if required. The macro transforms tables using SQL queries.

Or you may use the Spreadsheet from Table macro and turn the output of your Jira Issues in an Excel-like spreadsheet.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events