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?
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great, thank you. Figure it out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Regards,
Kishore Kumar Gangavath.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.