Email Templates: Difference between revisions
From Accelerator for SageCRM
No edit summary |
No edit summary |
||
Line 8: | Line 8: | ||
<add key="cases_mailmergeview" value="vCRMTogetherCase"/> | <add key="cases_mailmergeview" value="vCRMTogetherCase"/> | ||
---- | |||
You can control the SQL used to query the database (a setting in custompages/sagecrmws/web.config) | |||
<add key="getEMailTemplatesSQL" value="select emte_id, emte_name, emte_comm_from, emte_comm_replyto, emte_comm_note,emte_comm_email, emte_to, emte_cc, emte_bcc from emailtemplates WITH (NOLOCK) where emte_deleted is null order by emte_name asc" /> |
Latest revision as of 17:37, 28 August 2020
Email Templates use data ONLY from the view contained in the settings
entity_mailmergeview
EG
<add key="cases_mailmergeview" value="vCRMTogetherCase"/>
You can control the SQL used to query the database (a setting in custompages/sagecrmws/web.config)
<add key="getEMailTemplatesSQL" value="select emte_id, emte_name, emte_comm_from, emte_comm_replyto, emte_comm_note,emte_comm_email, emte_to, emte_cc, emte_bcc from emailtemplates WITH (NOLOCK) where emte_deleted is null order by emte_name asc" />