Table with Jira columns and user defined column

[Saba Muthuvelu]

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]

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]

Hi @Saba Muthuvelu  Welcome to Atlassian Community!

Where you created the Table, are you using excel or creating table in Jira ? 

[Saba Muthuvelu]

Hi @Vikrant Yadav

Thanks for your reply.

I created the table in the wiki page itself. I'm using the insert table option provided in the wiki page at the top to create a table.

(https://confluence.atlassian.com/doc/tables-136463.html - insert a table option)

Thanks!

[Vikrant Yadav]

Hi @Saba Muthuvelu  For this task, you have to use Jira issue macro.

https://support.atlassian.com/confluence-cloud/docs/insert-the-jira-issues-macro/

Using Jira issue macro, you can control column to display in table. 

[Saba Muthuvelu]

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.

[Vikrant Yadav]

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

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