Can there be a hyperlink inside of a pivot table?

Ethan Treece July 19, 2019

image.pngI've created this pivot table and it has the literal operation type for my link column. I'm wondering if I can shorten the names of these links so they save space and make it easier for the user to see the entire table.

For example, I want the table to just list out the ID of the defects (last 6 digits) but still have a link behind that's still clickable.

I'm using a Bob Swift SQL macro to query a data set. The data set includes the ID and I'm creating my own link variable by adding the code:

CONCAT('[',bugs.bug_id,']') as link

 Is there a way to alter my SQL code to display a shorter name but keep the link, or is there a way to use the pivot table filter to shorten the names?

2 answers

1 accepted

1 vote
Answer accepted
Ethan Treece July 22, 2019

I've found the answer, I just had to modify my SQL Query.


It's a simple syntax I just wasn't aware of. My new code looks like this and gives this result.

CONCAT('[',bugs.bug_id,'|',bugs.bug_id,']') as link,

 image.pngThe bug_id is now a hyperlink that leads directly to the unique webpage the bug is located on. Thanks to this post that I was able to find the answer.

Jeff Reed June 9, 2023

Hello, this is exactly what I'm trying to do. I have a static table that I pivot and I put the [Text|URL] pattern in. It still shows the literal text. Any suggestions?

Stiltsoft support
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.
June 9, 2023

Hi @Jeff Reed ,

I assume that the Pivot Table macro is ours - it comes from the Table Filter and Charts for Confluence app.

The macro shows what you have in the source table: if you have links, then they will be shown when aggregated as well.

In the initial question the links were created using the Bob Swift SQL macro - did you put the [Text|URL] pattern in the SQL query and not in the table itself?

And you may use our Table Transformer macro between your Pivot Table and source table to create clickable links as well.

Like # people like this
Jeff Reed June 10, 2023

Great, thank you. Figure it out.


Like Stiltsoft support likes this
0 votes
Deleted user July 22, 2019

Hi @Ethan Treece ,

We have a raised a support request for the same to troubleshoot the issue. Can you please log in to our portal with your Atlassian ID and provide us the Email ID. So that we will share the request with you.

And also please provide us the below information for further investigation.

Kishore Kumar Gangavath.


Ethan Treece July 22, 2019

Hi @[deleted] ,

I've created an account on your portal using the Email ID

The Confluence version that I'm using is Atlassian Confluence 6.13.4 and the Bob Swift SQL macro version is 10.x

I am unable to get the Confluence Storage Format probably because I am not an administrator of the server my Confluence space is running on.


Ethan Treece

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events