Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Samuel Stephens
Contributor
February 15, 2022

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.

1 answer

1 accepted

2 votes
Answer accepted
Fabian Lim
Community Champion
February 26, 2022

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
Contributor
February 27, 2022

Hey @Fabian Lim ,

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

Thanks for your help!

Suggest an answer

Log in or Sign up to answer