Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/26/2024 07:19 PM
An email template with slash("/") exists.
I tried to use the enhanced query to remove this shash, and I used it as follows.
SELECT 'abc def' AS ECMEMAILTEMPLATE__NAME, et.name as ECMEMAILTEMPLATE__PRIMARYKEY FROM ECMEMAILTEMPLATE et WHERE et.name = 'abc / def';
Before running this query, I tried running the query below as a test, but maybe because it's PRIMARYKEY, NAME doesn't seem to change.
SELECT 'abc_test' AS ECMEMAILTEMPLATE__NAME, et.name as ECMEMAILTEMPLATE__PRIMARYKEY FROM ECMEMAILTEMPLATE et WHERE et.name = 'abc';
As a result, I think we need to change the name of the email template using the enhanced query, is there any way?
Solved! Go to Solution.
09/26/2024 07:58 PM
You can change name from UI. Why you want to use enhanced query in this case ?
09/26/2024 09:08 PM
If I try to edit from UI it, 400 errors will occur because template name has slash. There's no way...
Can't I use the enhanced query? If so, would it be better to raise the ticket and request to delete the template?
09/27/2024 03:06 AM
Raise support ticket