Table Transformer extracting URL from Jira Results

[Maria Del Rosario Gonzalez]

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!

[Stiltsoft support · Accepted solution]

Hi @Maria Del Rosario Gonzalez ,

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

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*

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]

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

Thank you!!