Is it possible to add a hyperlink in a table transformer header?

[PA BRISON]

Hello

Is it possible to add a hyperlink in the header of a table transformer?

something like this in the SQL SELECT:

T2.'Key' AS FORMATWIKI("[Column header"+"|"+"https://my.url.com]"),

I get a syntax error when I try.

Ultimately I would like to have as the URL the query used to to create my T2 table (equivalent of "View in Jira", when you right click on the table in the edit view of Confluence). Is there a way to get this URL from T2 in the SQL query?

Thanks a lot in advance if you can help!

[Katerina Kovriga _Stiltsoft_]

Hi @PA BRISON ,

As for now your case is not possible, but we've added your idea to the backlog.

You may still try the following workaround:

Check both transpose options in the Table Transformer macro:

Use the following SQL query:

SELECT *,
FORMATWIKI("[" + T1.'Key' + "|" + "https://mycompany.com/" + "]") AS 'Key'
FROM T*

Now all the headers exсept the first one contain the links that you have put in your SQL query.