Email Templates: Difference between revisions
From Accelerator for SageCRM
(Created page with " Email Templates use data from the view contained in the settings entity_mailmergeview EG <add key="cases_mailmergeview" value="vCRMTogetherCase"/>") |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
Email Templates use data from the view contained in the settings | Email Templates use data ONLY from the view contained in the settings | ||
entity_mailmergeview | entity_mailmergeview | ||
| 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 16: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" />
