Table with Jira columns and user defined column

Question

Hi,

I have a table manually created as below:

Edit mode:

Ticket       comments

T100        my comments1

T101        my comments2

After saving:

Upon saving the page, is it possible to pull Jira details (Last updated date, Status) automatically for each ticket and display a table as below:

Ticket       Last updated date              Status                   comments

T100        05/20/24                            Accepted               my comments1

T101        05/23/24                            To do                     my comments2

Please let me know. Thanks for your help!

Stiltsoft support · Answer

Hi @Saba Muthuvelu ,

To lookup the output of your Jira Issues macro with a manually created table with comments, you may use the Table Filter, Charts & Spreadsheets for Confluence app (that is our add-on).

Here is an example from another Community thread (the second part of the thread) how to do it with the help of the Table Transformer macro.

The two tables are combined using the unique column (the issue key).

Also if the initial question was how to show only the tickets that are present in your manually created table (I mean that if in your manually created table you have two specific tickets and your JQL is wide and you gel all the tickets from the project but want to show data only for the two tickets), then you place the manually created table as T1 in the Table Transformer macro and use the LEFT JOIN function:

SELECT *

FROM T1 LEFT JOIN T2 ON T1.'Key' = T2.'Key'

And you may also check the Spreadsheet from Table macro: you'll be able to turn your Jira issues macro in the Excel-like spreadsheet and add comments along with calculations and conditional formatting easily.

Vikrant Yadav · Answer

Hi @Saba Muthuvelu  You can put JIRA JQL filter as well.

Checkout this video : https://www.youtube.com/watch?v=XKV-WA5RpD0

Saba Muthuvelu · Answer

Hi @Vikrant Yadav

How can I pass the ticket numbers to Jira issue macro? I want to pass all the ticket numbers from the initial table to the Jira macro automatically. Basically, I don't want to manually enter all the tickets in the Jira filter field inside the macro.

Thanks.