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; } } }

Confluence Table built from parameterized Jira Issue Macros

Jim Solomon

Hi, I'd like to create a high-level roadmap view in the form of a table in Confluence where:

Each row of the table is a swimlane (I can pull this from a picklist/enum from each issue in Jira)
Each column in the table is an estimated quarter in which it will ship (I can pull/derive this from a different field from each issue in Jira)

But, since there are lots of rows and columns, is there any way for me to automate the creation of this table, other than the straightforward way of creating the table, and then populating each cell of the table with a unique Jira Issue macro, each with its corresponding unique JQL string to pull the right things for that row/column, and rinsing and repeating this Row x Column times?

Can't help but wonder if there's some really cool thing I'm missing that would allow me to parameterize the JQL query for that Row/Column and blow out that whole table without doing nearly that much work (and maintenance!).

Anyone?

Accepted answers

Katerina Rudkovskaya _Stiltsoft_

Hi @Jim Solomon,

Not sure if that is exactly your case, but maybe our Table Filter and Charts for Confluence app will help.If you use the Jira Issues macro with the most general JQL (for example, all the issues for one or several projects), you may use our Pivot Table macro to group (aggregate) this dynamic table. The result pivot will be like a dashboard: all the changes from your Jira will be passed to Confluence through the Jira Issues macro and the Pivot Table macro will catch them automatically.

All comments

Katerina Rudkovskaya _Stiltsoft_

Jim Solomon

Thanks @Katerina Rudkovskaya _Stiltsoft_. Not sure I'm seeing the path forward.

I do follow your first point, which is to make a table with ALL of the issues using general JQL. As an example, that would give me something like this (simplifying):

and then through the magic of Pivots or other Macro wizardry, I would like to display it like this:

Is that possible?

Katerina Rudkovskaya _Stiltsoft_

Hi @Jim Solomon,

Yes, smth like this is definitely possible, please check the example below:

Wed 13-1.png

Wed 13-2.png

Instead of the manually created table that I've taken for my example, you should put the Jira Issues macro inside the Pivot Table macro (our macros support dynamic Confluence tables such as Jira Issues, Page Properties Report, Content Report Table).

Jim Solomon

Awesome, thank you!

Juliette Lallement _Elements Apps_

@Jim Solomon

Have you taken a look into the native Jira roadmap macro in Confluence ? It allows you to display your Jira roadmap inside Confluence and interact with it.

The good thing about it is that it will keep in sync with your Jira instance so you're sure any data displayed in Confluence is up-to-date.

Hope it helps

Jim Solomon

Thanks for the suggestion @Juliette Lallement _Elements Apps_. I've played around with Jira Roadmaps and it's a bit too "Gantt-chart-ish" for my purposes. I want a simple rollup of what's shipping by quarter across multiple swimlanes (projects) with higher information density than Jira Roadmaps provides. May have missed some tunability of it though.

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

pivot-table