Forums

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

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

PA BRISON
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 6, 2022

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!

1 answer

2 votes
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2022

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:

Thu 5-1.png

Check both transpose options in the Table Transformer macro:

Thu 5-2.png

Use the following SQL query:

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

Thu 5-3.png

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events