Table Filter, Charts & Spreadsheets for Confluence Table Transformer Custom Transformation - use cases with advanced SQL queries Current: Processing links with SQL PDF Download PDF Download page Processing links with SQL. Current page All pages Processing links with SQL Changing a link text and preserving it clickableUse case:You need to change a text for links and preserve it clickable.Solution:Switch the page to the edit mode.Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.Select the macro and click Edit.In the Presets tab select Custom transformation and click Next.Enter the following SQL query: SELECT T1.'Company', FORMATWIKI( "[Click here|" + T1.'Link'->tfView->match("href=([^ >]*)")->1->slice(1, -1) + "]" ) AS 'Link' FROM T* SQL Click Next. Save the macro and the page. Getting the link address from the linkUse case:You need to get the link address itself from the link.Solution:Switch the page to the edit mode.Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.Select the macro and click Edit.In the Presets tab select Custom transformation and click Next.Enter the following SQL query: SELECT *, T1.'Link'->tfView->match("href=([^ >]*)")->1->slice(1, -1) AS 'Link Address' FROM T1 SQL Save the macro and the page. ×