nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Stiltsoft support

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.

All comments

Stiltsoft support

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.

Roma Bubyakin _Wombats Corp_

Hello @Lukas Mühlemann

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

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

Hi @Roma Bubyakin _Wombats Corp_

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.

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

Roma Bubyakin _Wombats Corp_

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table

table-filter

table-filter-and-charts

table-transformer

table-filter-charts-spreadsheets