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

[Kumar, Praveen (GCOO - CTO - Engineering Services BAU L, Chief Technology Office)]

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.