07/08/2024 10:50 PM
I am trying to update the email template body of few emails where I can find a specific email id inside the body induced as hyperlink. I have developed a query just to check for 1 template and here it is
select name as ecmemailtemplate__primarykey, replace(templatecontent, '***', '###') as ecmemailtemplate__templatecontent from ecmemailtemplate where templatecontent like "%**%" and name= "##";
The above query is working fine in preview and i am seeing the results I want. When I try to run it , it is failing with message stating
2024-07-08T12:55:00.295856299Z stdout F 2024-07-08 12:55:00,295 [quartzScheduler_Worker-7] ERROR utility.CustomQueryService - Exception Inside transaction: named capturing group is missing trailing '}'
No matter how many times I change the query , I am getting same error and everytime the preview is successful.
Can anyone help me understand the situation here ?
Thanks in Advance!
07/09/2024 12:17 AM
@tejpusal try below
SELECT
name AS ecmemailtemplate__primarykey,
REPLACE(templatecontent, '***', '###') AS ecmemailtemplate__templatecontent
FROM
ecmemailtemplate
WHERE
templatecontent LIKE '%**%'
AND name = '##';
07/09/2024 11:27 PM