Table Transformer macro - searching for a substring in the Description field

Emil_eiquvw

Hi,

I would like to search for a substring in the Description field, but it does not return anything although the substring is in the Description field. I've just started to check this topic on the internet and found that it is not that easy, but I would be curious if there is any workaround for that with the Table Transformer macro.

 

My SQL is the following and it does not return anything although the substring is in the Description field and with other fields searching for a substring works fine:

 

SELECT 'Key', 'Summary', 'Description',
CASE
WHEN 'Description' LIKE "%Dear%" THEN "Dear is found"
END AS 'Calc_field'
FROM T1
ORDER BY 'Key'

 

Thanks,

Emil

Katerina Rudkovskaya _Stiltsoft_

Hi @Emil,

It seems to be smth unusual with the "Description" field parsing: your SQL query is a working one and it operates as expected with other fields coming from the Jira Issues macro. We suppose that it may come from the "\n" end of the lines, we'll look into the issue closely.
As a workaround, you may use the following query:

SELECT 'Key', 'Summary', 'Description',
CASE
WHEN MATCH_REGEXP(T1.'Description', "dear")
THEN "Dear is found"
END AS 'Calc_field'
FROM T1
ORDER BY 'Key'
It works well for me.