USP_EMAILTEMPLATE_GETLIST
Returns email templates by type
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TYPECODE | int | IN | Type |
Definition
Copy
CREATE procedure dbo.USP_EMAILTEMPLATE_GETLIST
(@TYPECODE Integer)
as
select
EmailTemplate.ID as Id,
EmailTemplate.Name,
EmailTemplate.Guid
from dbo.EmailTemplate
where EmailTemplate.Type = @TYPECODE and EmailTemplate.Deleted = 0