Build table in confluence using Jira data, project id entered dynamically or from drop down

Question

Trying to allow user to either enter jira project id in a text edit field on a confluence page or allow them to select from dropdown and then in turn display data from that jira record in table format in confluence.

Looking to display PI Objectives on a page in confluence for executive reporting where there is less JIRA screen noise.

Katerina Kovriga {Stiltsoft} · Answer

Hi @Eric Senn ,

As I see, you need to somehow filter the Jira Issues macro in a more user friendly way than JQL query.

We can suggest using the Table Filter and Charts for Confluence app. Wrap your Jira Issues in the Table Filter macro and apply the required filters:

Here we show several projects with the help of the general JQL inside the Jira Issues macro body and perform filtering in the page view mode with the help of the Table Filter macro.

Please, check even more use cases how to create visualized Jira reports in Confluence. As your hosting type is Cloud, you'll need the Table Toolbox macro to nest several macros, other steps will be the same.

And here is a short video tutorial how to filter Jira Issues in Cloud (app. 2 min). Hope it helps your case.

Nic Brough -Adaptavist- · Answer

The Jira macro can do most of this.  It's not "enter text in a box", it supports a complete JQL query (so "project = xyz")