I need help, for Merging JIRA Issue Table

Josée Dufresne December 2, 2022

Hello,

Here is what I would like to have this : 

2022-12-02_13-39-02.jpg

but i get this :

2022-12-02_13-41-12.jpg

This is my SQL code :

SELECT T1.'T',T1.'Key',T1.'Summary', T1.'Linked Issues', T1.'Date prévue',
CONCAT(FORMATWIKI(T2.'T' , " \n")) AS 'T-linked issues',
CONCAT(FORMATWIKI(T2.'Key', " \n")) AS 'Key-linked issues',
CONCAT(FORMATWIKI(T2.'Summary', " \n")) AS 'Summary-linked issues',
CONCAT(FORMATWIKI(T2.'Status', " \n")) 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 ?

1 answer

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 3, 2022

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.

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 7, 2022

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events