How do I return query results as a comma separated list in SQL?

Laurie Huth April 8, 2022

Issue: I am using the Jira Issue/Filter macro in a Confluence page. In Jira, there is a list of items selected. I want to have commas or semi commas when I pull it into Confluence. 

For example, currently in Jira there is an External Document field:

Screenshot 2022-04-08 100405.png

Then the table cell in Confluence shows: (note, no commas or anything to separate the list)

Screenshot 2022-04-08 100526.png

 

Question: How do I enter commas or semicolons or something to separate each item?

 

Here is my SQL so far: 

FORMATWIKI(SUM("External: " + 'External Document')) AS 'Resources'

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events