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
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*
Could someone please explain what this part of the query is doing for a newbie? T1.'Description'->getView()
It looks like you're new here. Sign in or register to get started.
