How can I insert several Jira contents as a page property field in Confluence and output them as a r

[Lukas Mühlemann]

I would like to insert information from Jira as page properties in a Confluence page so that I can make a summary (propertiereport) on another page.

When I use the normal Jira macro, the table is displayed with many columns and two rows. As a result, these can only be displayed completely in the report.

I have tried to use the table transformer to display the table differently so that I get two columns and several rows. However, this table cannot then be displayed in the report.

Can someone help me?

[Stiltsoft support · Accepted solution]

Hi @Lukas Mühlemann ,

Try to switch from the Page Properties/Page Properties Report macros to the Table Excerpt/Table Excerpt Include macros, they perform better with macro generated tables.

[Lukas Mühlemann]

Hi @Stiltsoft support 

nice try, but when I want to summarize several pages in one report, several tables are displayed. In the page properties report, these are merged into one table.

[Lukas Mühlemann]

When I use the Tabeltransformator it works.

but I miss the option to select the fields that i want to show in the report. because I dont need all the informations in all of the reports.

[Stiltsoft support]

For the first point: check the "Show as a report" option in the Table Excerpt Include macro settings. Then your tables will be shown as a one combined table and you won't need the Table Transformer macro for merging.

What concerns the second point, you have two options:

• You may wrap your Table Excerpt Include in the Table Filter macro and hide the unwanted columns
• You may wrap your Table Excerpt Include in the Table Transformer macro and list the columns that you want to show (SELECT 'Column 1', 'Column 2', 'Column 4' FROM T*)

[Lukas Mühlemann]

@Stiltsoft support Thank you!!

[Roma Bubyakin]

Hello @Lukas Mühlemann 

What exact information would you like to show on the page?

[Lukas Mühlemann]

Hi @Roma Bubyakin 

Information from a Jira issue, such as start and end date, assigne,...

However, I would like to have these as a single field so that I can compile and filter them in an overview.
So that I don't have to enter and update the information manually in Confluence, I would like to import it dynamically from Jira.

[Roma Bubyakin]

I got it.

You can use our app User Macro for Confluence Cloud for that.

There are a lot of possibilities to customize it to your needs.

You can gather any information from Jira and Confluence.

Additionally, you can increase flexibility and reusability with User Parameters. In example below users can set particular project to be shown.

Here is the template that could be changed based on your needs (I would be happy to help you with that):

#set ($res = $JiraManager.get("/rest/api/2/search?jql=project=${parameters.projectKey}&maxResults=3"))

<table class="aui aui-table-sortable">
  <thead>
    <tr>
      <td>Key</td>
      <td>Summary</td>
      <td>Assignee</td>
      <td>Created at</td>
      <td>Updated at</td>
      <td>Due</td>
      <td>Status</td>
    </tr>
  </thead>
  <tbody>

  #foreach ($issue in $res.issues)
    <tr>
      <td>$issue.key</td>
      <td>$issue.fields.summary</td>
      <td>$issue.fields.assignee.displayName</td>
      <td>$issue.fields.created</td>
      <td>$issue.fields.updated</td>
      <td>$issue.fields.duedate</td>
      <td>$issue.fields.status.name</td>
    </tr>
  #end

  </tbody>
</table>

Best Regards, Roman

Wombats Corp, CEO

[Lukas Mühlemann]

Thank you, but I am not authorized to buy any more macros.

[Roma Bubyakin]

It's ok.

Thank you, for the real-case example!