Email Templates
From Accelerator for SageCRM
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" />