URL updates in Email Templates

[harishyara]

Hi Team,

We are migrating from v5.5 to v24.2, currently we do have 100+ email templates body containing current version instance url, after migration if we get new url, is there a way that we can replace the old url with new instance url for all email templates without going to one by one email and do manually? Please advise.

[rushikeshvartak]

• Always best practice is don't keep any domain url in Email template
• use ${baseUrlForEmail} https://forums.saviynt.com/t5/ars/base-url-usage-in-email-templates/ta-p/37339 
• If they are other urls/link other than saviynt then export template / reimport
• or use enhanced query

[Raghu]

@harishyara  we dont have any alternative , sometimes multiple sharepoints links based customer requirement.

We done one by one only, if dont any url you can use transport function to import it.

[harishyara]

@Raghu - Okay in that case, could you please confirm is there a way that we can get list of all email templates which contains current instance URL in the email body ?

[rushikeshvartak]

select name from ecmemailtemplate where templatecontent like '%abc%'

[harishyara]

Hi @rushikeshvartak - I tried getting this message

[rushikeshvartak]

select name from ecmemailtemplate where templatecontent like '%.com%'

[dgandhi]

Its ecmemailtemplate and not templates(as shown in your screenshot).