Table Transformer - retrieving the status and assignee of Linked Issues

[Emil]

Hello,

Is it possible in any way (e.g. with a subquery) with Table Transformer to retrieve the status and assignee of Linked Issues?

Emil

[Katerina Kovriga _Stiltsoft_]

Hi @Emil ,

Not sure what you mean - the Table Transformer macro works with the output of the Jira Issues macro. Which fields you see in the table returned by the Jira Issues macro, that fields will be "seen" by the Table Transformer macro.

The Table Transformer macro alone does not pull any data from Jira.

[Emil]

Hi Katerina,

Thanks for your quick reply. In the Jira Issues macro I get the Key, Summary, Assignee, Linked Issues, etc. fields, and I would like to get not only the content of the Linked Issues field which is the key of those issues, but also retrieve somehow the Status and Assignee of the Linked Issues if possible and put them to some calculated fields.

[Katerina Kovriga _Stiltsoft_]

If you could retrieve the required fields in the separate table/tables, then the Table Transformer may help you to merge the master table with additional tables using, for example, the linked issue keys as unique IDs for merging.

You may check this two similar threads:

https://community.atlassian.com/t5/Confluence-questions/Table-Transformer-Select-Through-Multiple-Items-Within-Key-Cell/qaq-p/1653652

https://community.atlassian.com/t5/Confluence-questions/Table-Transformer-Only-display-quot-Duplicates-quot-Issue-Link/qaq-p/1806772

[Emil]

Thanks a lot, it looks promising. I will try it out.