HTML Rendering in Table Transformer Macro

Fabian Raczkowski February 20, 2024

I am currently facing an issue with the rendering of HTML content within a Table Transformer Macro in Confluence. Specifically, I have embedded a Jira Issue Filter Macro within the Table Transformer Macro to filter issues and reduce column width. However, some of the issues retrieved from Jira contain HTML code within their descriptions. Unfortunately, this HTML code is not being rendered properly and is displayed as plain text instead.

 

I would greatly appreciate any assistance or guidance you can provide to help resolve this issue and ensure that the HTML code within the issue descriptions is rendered correctly within the Table Transformer Macro.

html_confluence.png

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2024

Hi @Fabian Raczkowski ,

You may try the HTML_DECODE function for the case:

HTML_DECODE(T1.'Data'::string) AS 'New Data'

Fabian Raczkowski February 20, 2024

Hi, 

that´s what i get after trying:

 

TypeError: alasql.fn.HTML_DECODE is not a function

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2024

Hi,

It means that the version of the app is not up-to-date.

If your tags are wrong and you are on Data Center where you need to update the app manually, please make sure that you have the current version that is 10.4.0.

If you are on Cloud, the updates should reach your instance automatically. In September we released the Spreadsheet from Table macro and only this version needed manual update - you may ask your Confluence administrator if there is no an "updates available" status in the app's administration section. 

Like # people like this
oliver.glowa February 27, 2024

Hello @Stiltsoft support ,

you're right, the app on our system is version < 10.3. We need to update the app.

Beside,

the mentioned SQL command "HTML_DECODE" is not listed in your documentation, although the command is available since 10.3.0.

https://docs.stiltsoft.com/tfac/dc-server/general-syntax-and-sql-functions-available-42246251.html

Could you please initiate to your team, that this page will be updated with an actual list of all available commands?

Thx 4 u'r help,

Oliver

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 27, 2024

Hi @oliver.glowa ,

We hope that the bug with the Jira Issues macro will be resolved and we won't need this workaround in the future.

But I'll raise the question regarding the up-to-date list of commands within the team, thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events