Confluence Smart Links From Table Transformer

Casey Carll

As far as I understand it, the process in which a URL is changed automatically while editing a page in confluence when pasting the URL is called Smart Links.

The question I have is, is there a way to recreate this with dynamic data?
I am retrieving table excerpt data from fast jira list JQLs.
The focus of which has to do with the confluence pages linked to these jiras.
I have created a desired table through various pivot tables and table transformers with the data retrieved from table excerpt inclusions.

The specific thing I wish to do is automatically generate the page names of the confluence pages, much like smart links does when pasting the URL into a confluence page.
Is there a way to do this through table transformation or another method?

I have been able to create hyperlinks of the Page ID links already using table transformation and I wish to be able to read the page names without clicking the links.
I also am not an administrator user and do not have any funds to get add-ons for confluence.

Katerina Rudkovskaya _Stiltsoft_

Hi @Casey Carll,

Unfortunately, I don’t think that the Table Transformer macro will help with the case.
It can, for example, rename a bunch of links in the column to smth short and clickable (please navigate to the “Creating clickable links” section).

And you may try to split your full link by some symbol to leave only the part with the page name. But not every link is “pretty”, many page links have not titles but page IDs in their URLs. So, this option also won’t do
.
The Table Transformer macro itself recognizes the @PAGETITLE variable. For example, the query “SELECT @PAGETITLE AS 'Page Title' FROM T*” will return the page title of the current page, but not the page titles of other pages.

To get page titles as page meta data trough the Table Excerpt Include macro is also not an option, as I understand. Because you don’t need to see page titles of the pages where your Table Excerpt macros are placed, you need to see the page titles of Confluence pages that are linked to your Jira issues.

So, sorry but nothing helpful comes to my mind at the moment.