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" />