USP_DATALIST_EMAILDATASOURCE

Returns the set of data sources used by a particular site.

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTSITESID	int	IN	Client site ID
@EXCLUDEBACKOFFICEID	nvarchar(max)	IN	Excluded back office system ID's

Definition

Copy



create procedure dbo.USP_DATALIST_EMAILDATASOURCE
(
    @CLIENTSITESID int,
    @EXCLUDEBACKOFFICEID nvarchar(max)
)
as
    set nocount on;

    select distinct
       v.DataSourceId,
       v.DataSourceName,
       v.BackOfficeSystemId
    from dbo.vwEmailTemplateDataSources v
    inner  join EmailTemplate et on v.DataSourceID=et.DataSourceID
    WHERE NOT EXISTS (SELECT NULL FROM dbo.fnCSVIDsToTable(@EXCLUDEBACKOFFICEID) WHERE ID = BackOfficeSystemID)
        and v.DataSourceID <> 320 -- exclude marketing templates

        and (et.ClientSitesID=@CLIENTSITESID or @CLIENTSITESID is NULL)
    --ORDER BY BackOfficeSystemId, DataSourceName;