Hi,
In the Epic JIRA description field I have a URL between 2 delimiters. How can I extract the URL using the Table transformer SQL, while maintaining the HTML hyperlink formatting.
Thanks!
Hi @Madhu Sagar ,
Please can you share what do you exactly see in your cell and how do you want your result cell to be seen after the transformation?
There is a possibility to extract the URL or its part from the hyperlink (https://community.atlassian.com/t5/Confluence-Cloud-questions/Table-Transformer-extracting-URL-from-Jira-Results/qaq-p/2581858) and then we can try, for example, to create a new clickable link using this URL.
So lets say Description field of Epic 1234 in JIRA has this content -
https://community.atlassian.com is an important website
Using Table Transformer, I want Confluence to display below table. The links are of varying length of course.
Epic ID Link
1234 https://community.atlassian.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Madhu Sagar ,
Thank you for the clarification!
Hope this workaround will help your case:
SELECT *,
MATCH_REGEXP(T1.'Description'->getView(), "href=\"(.*?)\"")->1 AS 'Optional column', /* Delete this line, it is used just to show that we extract links as text */
FORMATWIKI("[Link|" + MATCH_REGEXP(T1.'Description'->getView(), "href=\"(.*?)\"")->1 + "]")
AS 'Link from the Description'
FROM T*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could someone please explain what this part of the query is doing for a newbie?
T1.'Description'->getView()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The getView() is one of the JavaScript methods - several JavaScript functions were introduced along with the AlaSQL library for advanced cases (like this one where we need to grab not the beautiful link text but the hidden link itself) https://docs.stiltsoft.com/tfac/cloud/general-syntax-and-sql-functions-available-42246251.html#GeneralsyntaxandSQLfunctionsavailable-JavaScriptmethods
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.