FORMATWIKI function where "
" is no longer providing the equivalent of a carriage return?

Question

We had this code in our confluence page on the Table transformer macro

Code:

SELECT
X.'Feature Key'
,X.'Feature Name'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Key' + " 
")) as 'Work Key'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Summary' + " 
")) as 'Work Description'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Created' + "
")) as 'Ticket Created'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Updated' + "
")) as 'Ticket Updated'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Status' + "
")) as 'Ticket Status'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Assignee' + "
")) as 'Colleague'
from
(SELECT
T1.'Key' as 'Feature Key'
,T1.'Feature Name'
,OrderedT2.*
FROM T1
LEFT JOIN (SELECT * FROM T2 ORDER BY T2.'Key') as OrderedT2
ON T1.'Feature Name' = OrderedT2.'Feature Link'
) As X
GROUP BY X.'Feature Key', X.'Feature Name'
ORDER BY X.'Feature Key'

Result should be link the values are return as a links to jira but the values are just returning as a plain text instead of links.

Kumar, Praveen (GCOO - CTO - Engineering Services · Answer

Hi @Daniel Berežnoi,

Appreciating your Response!

Some how with the above query it return the values as links but not with the next line again.

its returning all the values with out the delimiter as a para of links.

Could you please let us know any other options available.

Daniel Berežnoi · Answer

Hi Kumar,

This is Daniel from Stiltsoft, the developers of Table Filter, Charts & Spreadsheets for Confluence.

Please try the following formula, replacing the 
 with a space (" "). Also, ensure that a comma is separating the space and the column name:

CONCAT_VIEW_AGGR(FORMATWIKI(X.'Key', " "))

Let me know if this works for you.

Daniel