Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Laurie Huth
Contributor
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:

undefined

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

undefined

 

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