Display info of jira issues linked together in Jira

Question

Hello,

I have 2 list of Jira issues :

- Task issue

- Objective issue

Task issues are manually linked in Jira to Objective issues via the jira issue link of type "relates to"

I would like to display in confluence in a same table, the list of all objectives with their associated tasks (when there are links).

I tried using Table transformer macro from "Table Filter" plugin to do that. But I didn't manage to do it.

Below, one thing I tried to do :

- I created 2 tables in confluence based on jira issue macro : 1 for tasks list and 1 for objectives list => result is ok

- I tried to reference these 2 tables through the "table excerpt" or "table excerpt include" macros from "table filter" plugin => result is ko : it doesn't display the table content anymore : instead a link to a page search result is displayed.

So finally, I don't know how I can reference the 2 jira tickets lists into one common table.

If you have any idea how to solve this problem, don't hesitate to reply. Also, if you have a better solution to cover my initial need (ie : display the info of many Jira issues linked together), don't hesitate :)

Thank you for your help

Adrianna Bell · Answer

I don't know if this helps or not, but I used this to create a list of all linked issues within my tickets where BFQD is my project key.  This gives me a complete list of all of the linked issues.

issueFunction in linkedIssuesOf("project=BFQD") AND issueLinkType = "relates to" AND statusCategory != "Done"

Stiltsoft support · Answer

Hi @test_atlassian ,

The Table Filter and Charts for Confluence app is our plugin.

Indeed we have a use case where you can look up two Jira tables: with issues and with linked issues. You may check it here https://docs.stiltsoft.com/tfac/cloud/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-MergingJiraIssuetablesbylinkedissuesandkeys

If your source tables differ from the example, you may refer to our support.

Attach the two screenshots of your Jira Issues macros in a published state with visible headers - we'll try to help with the query.

As for now it's hard to elaborate on the question: I can't see why you need the Table Excerpt/Table Excerpt Include macros at all if you created 2 tables in Confluence based on Jira Issues macro. You don't need to reuse your tables as they are macro generated, just wrap these two Jira macros in the Table Transformer macro.

The issue with the "it doesn't display the table content anymore : instead a link to a page search result is displayed." also seems strange, we are not aware of such behavior of the Table Excerpt Include macro.

test_atlassian · Answer

Hello Sagar,

thanks for your answer.

I am not sure to know if it covers my needs completely.

In fact, I already manage to gather :

- in a table the list of tasks with ids of related objectives

- in an other table the list of objectives with ids of related tasks

I would like now to merge these 2 tables into one unique table to see quickly, for each objective, which ones are covered by tasks and display some tasks details (ex : like summary or any custom field and not only the task id).

So, if I draw a parallel with SQL, I would like to make a JOIN request between my 2 tables.

Does JQL linkedIssues() function allows to do such a thing ?

Thanks in advance and I apologize in advance if my explanations are not clear enough : don't hesitate to ask me more detail if it is the case.