I need help, for Merging JIRA Issue Table

Question

Hello,

Here is what I would like to have this :

but i get this :

This is my SQL code :

SELECT T1.'T',T1.'Key',T1.'Summary', T1.'Linked Issues', T1.'Date prévue',
CONCAT(FORMATWIKI(T2.'T' , " 
")) AS 'T-linked issues',
CONCAT(FORMATWIKI(T2.'Key', " 
")) AS 'Key-linked issues',
CONCAT(FORMATWIKI(T2.'Summary', " 
")) AS 'Summary-linked issues',
CONCAT(FORMATWIKI(T2.'Status', " 
")) AS 'Status-linked issues'
FROM T1 LEFT JOIN T2 ON T1.'Linked Issues'->split(" , ")->indexOf(T2.'Key'::string) > -1
GROUP BY T1.'Key', T1.'T',T1.'Summary', T1.'Linked Issues', T1.'Date prévue'

The version of Confluence I use is :

Confluence 7.13.7

Can you help me ?

Stiltsoft support · Answer

Hi @Josée Dufresne ,

In case you prefer a confidential portal, please feel free to create a support ticket via our Jira Service Desk - we'll look into the issue there.

Stiltsoft support · Answer

Hi @Josée Dufresne ,

Please provide us with two screenshots of the tables that you are trying to merge (as they are without any macros): with visible headers and 1-2 rows of data for an example. We'll try to provide you with a suitable query.