Retrieve proforma form data in a Jira ticket to output as a live table in Confluence

[Samuel Stephens]

I am trying to collect the data directly from a proforma form within a Jira service desk ticket and  display it in a table within Confluence.

I am not a Jira Admin so cannot create additional custom fields that would probably be achievable with a simple Jira macro.

I have the current list of tickets within Confluence as a Jira macro, inside of a table transformer macro, inside of a table filter. This outputs the default options for fields and does not show the custom data in the proforma form.

I need to write either an SQL query for the table transformer to retrieve the data inside the form, and output in as fields in the table or find some other way to automate the export of that data.

I just can't figure out how to get the data out of the form with SQL and output it in a table on the Confluence page.

[Fabian Lim · Accepted solution]

Hi @Samuel Stephens

Welcome to the community!

I would ask the admin to create the customfield for you so that you can map it in the forms. Then use the jira macro to call it from confluence. It would save you from a huge headache to figure it out with the SQL option you mentioned, which I don't know if it's even possible.

Regards

[Samuel Stephens]

Hey @Fabian Lim ,

We ended up opting for this outcome before this but it's worked a treat!

Thanks for your help!