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

[Kumar_ Praveen _GCOO - CTO - Engineering Services BAU L_ Chief Technology Office_]

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' + " \n")) as 'Work Key'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Summary' + " \n")) as 'Work Description'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Created' + "\n")) as 'Ticket Created'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Updated' + "\n")) as 'Ticket Updated'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Status' + "\n")) as 'Ticket Status'
,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Assignee' + "\n")) 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.

[Daniel Berežnoi]

Hi Kumar,

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

Please try the following formula, replacing the \n 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