Populate a confluence table with jira information

[Simon B]

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?

[Stiltsoft support]

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]

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):

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]

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.