Table Transformer - Character Match

Question

Hello

I use table transformer plugin

My Story or Epics can contain special characters like  ³ or Ä.

If I join Epics (Table 3) and Story (Table 4) with this

LEFT JOIN T4 ON T3.'Epic Name' = T4.'Epic Link'

It will not find a match.

Working for alphanumeric characters, [ ] …

How do I make the query more tolerant or convert it to an equal character set?

Thank you

Katerina Rudkovskaya _Stiltsoft_ · Answer

Hi Matthias,

The issue comes from Jira Issue Epic Link/Epic name as source data.

Here's how columns look like without Table Transformer:

There are issues with the Epic Name field encoding of special characters in Jira Issue macro; here are Atlassian tickets you can vote for:

* https://jira.atlassian.com/browse/CONFSERVER-54431
* https://jira.atlassian.com/browse/CONFSERVER-58379
* https://jira.atlassian.com/browse/CONFSERVER-60082

As a workaround, you can use Table Transformer with the following SQL query to replace HTML code with characters:

SELECT

REPLACE(REPLACE(T1.'Epic Link', CONCAT("&", "#xC4;"), "Ä"), CONCAT("&", "#xB3;"), "³") as 'Epic Link',

REPLACE(REPLACE(T1.'Epic Name', CONCAT("&", "#xC4;"), "Ä"), CONCAT("&", "#xB3;"), "³") as 'Epic Name'

FROM T*

Matthias Mödinger · Answer

Thanks for you detailed answer. My version is v12.3.1, cannot update easily since it is company controlled.

My underlying table is a Jira Issue/Filter with JQL query like

project in (PROJECTNAME) AND type in ("Epic")

In Jira search query it gives me epic Summary and name like
CR1172 - [E³ 1.2

Table transformer table is displayed like this:

Summary                 |    Epic Name 
-------------------------------------------------------
CR1172 - [E³ 1.2      |    CR1172 - [E³ 1.2

Matthias Mödinger · Answer

deleted