Remove html tags from table transformer results

[Alan Harding]

I am displaying fields from Jira Epics on a Confluence page using the Insert Jira Issue/Filter macro inside a table transformer macro.  Everything is working perfectly except one of the fields I am showing is of the type Wiki Style Renderer.  Even if the text has received no formatting in Jira I still get <p> and </p> tags around the text.  And of course if the text does have formatting I see all those html tags as well.

Is there any way to transform this field to just plain text and remove the html?  I tried the following but it is not having any effect.  

SELECT
T1.'Acceptance Criteria (old)'::string->replaceAll("/(<([^>]+)>)/ig"," ")
FROM T*
ORDER BY DATE(T1.'Target end') ASC

The regex seems to be the issue, if I replace it with <p> then it works as expected.

[Stiltsoft support]

Hi @Alan Harding ,

It seems that the issue is caused by a Confluence bug that was reported on 17/Jan/2024 https://jira.atlassian.com/browse/CONFSERVER-94113.

You may check this link and add your vote there.

Meanwhile, we can suggest the following workaround via the Table Transformer macro:

SELECT T1.'Data',
HTML_DECODE(T1.'Data'::string) AS 'New Data'
FROM T*

Please note that the version on the Table Filter, Charts & Spreadsheets app should be 10.3.1 or a newer one for the function to work properly.

Please check it with your Confluence administrator and update if required.

[Stiltsoft support]

Hi @Janice  ,

As we see, our custom tags were added to the system - thank you so much! We always add them to the related questions.

Please one more issue from our side: last week we officially renamed our app from "Table Filter and Charts for Confluence" to "Table Filter, Charts & Spreadsheets for Confluence".

Please can you update one of our tags as well: table-filter-and-charts -> table-filter-charts-spreadsheets?

Other tags are good as they are.

Thank you!