Table Transformer - Character Match

[Matthias Mödinger]

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_]

Hello, 

I tried to reproduce the case and it works as expected. You probably need to update the app to it latest version 13.0.1.

[Matthias Mödinger]

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

[Katerina Rudkovskaya _Stiltsoft_]

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]

deleted