Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Table Transformer extracting URL from Jira Results

Maria Del Rosario Gonzalez January 17, 2024

I have been using the Table Toolbox Macro in Confluence with a lot of success and love the functionality.

I am facing an issue with a particular use case:

I would like to take a field returned from a Jira SQL filter that is a link (when I hover over it, I can see the URL) and select the last part of the URL; so just the number part is displayed.

I am attaching a partial screen display to illustrate the problem.

Is there a way to accomplish this?

Thanks in advance for your help!PostedQuestion.PNG

1 answer

1 accepted

2 votes
Answer accepted
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.
January 18, 2024

Hi @Maria Del Rosario Gonzalez ,

If you use the Legacy Jira macro, we can suggest trying the following workaround:

Thu 13-1.png

Here I use our project for spam as an example. :) 

The following SQL query helps to extract the issue key from the 'Summary' link hidden under the description string:

SELECT *,
MATCH_REGEXP(T1.'Summary'->getView(), "href=\"(.*?)\"")->1->split("/")->slice(-1)
AS 'New column'
FROM T*

Thu 13-2.png

If the example doesn't suit your needs, please refer to our support. The portal is confidential, so you'll be able to share more details. 

Maria Del Rosario Gonzalez January 18, 2024

Excellent!  You guys are amazing with your support.  This tool is so useful and has provided so much value!

Thank you!!

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events