Export result from JQL to Confluence page in table format without auto syncing

[Linda Shen]

I am working on creating a weekly project status report on Confluence. My plan is to start with a JQL, pull data from JIRA, export it to Confluence, then tailor the content to suit executive audiences. If I copy & paste the filter into Confluence, a table will appear with the list of the issues and I will be able to configure the fields per my needs. However, this approach have two problems I don't have solution for:

1. The table is not editable directly in Confluence and there is no way for me add a column for notes (to tailor to audience)

2. The page is dynamically linked to JIRA, this causes confusion--- status on 1/1/2021 should not change ever.

Has anyone encounter similar issues? Thanks in advance.

[Fabian Lim · Accepted solution]

Hi @Linda Shen

1. Correct, you can't update the fields from the jira ticket. 

2. Using jql for reporting in confluence it's hard especially when you want static reports.  Statuses, fields, will change week by week.

In my experience, we put the jira issue keys in a table and have the columns that are manually updated for additonal comments.  The benefit of it is that they will get mentioned in the ticket if someone needs more information.

[Linda Shen]

@Fabian Lim thanks for sharing your insights. Your approach makes sense to me. Is there some easy way to "put the jira issue keys in a table"? what I did was to export the JQL to Excel, then copy from there, but that seems silly, doesn't it? Again, thanks for your help!

[Linda Shen]

@Katerina Kovriga _Stiltsoft_ thanks very much, I will give it a try.

[Katerina Kovriga _Stiltsoft_]

Hi @Linda Shen ,

The first case can be solved with the help of our app - Table Filter and Charts for Confluence.

You'll be able to add manually created columns with notes to your Jira Issues table with the help of the Table Transformer macro. Please check out the second part of this community thread.