spGetEmailTemplatesForDataSource
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @clientsID | int | IN | |
| @dataSourceID | int | IN | |
| @IncludedDeleted | bit | IN |
Definition
Copy
CREATE procedure [dbo].[spGetEmailTemplatesForDataSource]
(
@clientsID int,
@dataSourceID int,
@IncludedDeleted bit
)
as
select et.[ID]
,et.[ClientsID]
,et.[Name]
,et.[Description]
,et.[OwnerID]
,et.[Deleted]
,et.[Guid]
,et.[ContentHTML]
,et.[ContentText]
,et.[FromAddress]
,et.[FromDisplayName]
,et.[Subject]
,et.[Priority]
,et.[ReplyAddress]
,et.[ReturnReceipt]
,et.[ReturnReceiptAddress]
,et.[ForwardDSN]
,et.[ForwardDSNAddress]
,et.[Type]
,et.[IsInternalUse]
,et.[DataSourceID]
from emailtemplate et
where et.datasourceid=@dataSourceID
and et.clientsid=@clientsID
and et.deleted in (0, @IncludedDeleted)
order by [et].[name]