Can there be a hyperlink inside of a pivot table?

[Ethan Treece]

I'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('[https://bz.labs.lenovo.com/show_bug.cgi?id=',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?

[Ethan Treece · Accepted solution]

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

[Text|url]

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,'|https://bz.labs.lenovo.com/show_bug.cgi?id=',bugs.bug_id,']') as link,

 The 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.

https://community.atlassian.com/t5/Jira-questions/JMWE-URL-hyperlink/qaq-p/1049991

[Jeff Reed]

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]

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.

[Jeff Reed]

Great, thank you. Figure it out.

[Deleted user]

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 https://bobswift.atlassian.net/servicedesk/customer/portal/1 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.

• Confluence version that you are using along with the app version.
• Share us the storage format by following the steps from How to Get Confluence Storage Format page.

Regards,
Kishore Kumar Gangavath.

[Ethan Treece]

Hi @[deleted] ,

I've created an account on your portal using the Email ID etreece@lenovo.com

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.

Thanks,
Ethan Treece