USP_DATALIST_CRM_BBPAY_TEMPLATE

Returns all CRM BBPay Template records.

Parameters

Parameter	Parameter Type	Mode	Description
@TEMPLATEID	uniqueidentifier	IN	BBPay Template ID
@CLIENTSITESID	int	IN	BBNC Client Site ID

Definition

Copy




CREATE procedure dbo.USP_DATALIST_CRM_BBPAY_TEMPLATE(
    @TEMPLATEID uniqueidentifier = null,
    @CLIENTSITESID integer = null
)
as
set nocount on;

select
    CRMBBPAYTEMPLATE.[ID],
    CRMBBPAYTEMPLATE.[HTMLSOURCE],
    CRMBBPAYTEMPLATE.[CSSSOURCE],
    CRMBBPAYTEMPLATE.[IMAGEPLACEHOLDERS],
    CRMBBPAYTEMPLATE.[CLIENTSITESID],
    CRMBBPAYTEMPLATE.SITECONTENTID,
    CRMBBPAYTEMPLATE.SITEPAGEID,
    CRMBBPAYTEMPLATE.DELIVERYCHANNELID,
    BBET.ID ENVIRONMENTTEMPLATEID
from
    dbo.BBPAYENVIRONMENTTEMPLATE BBET 
    inner join dbo.CRMBBPAYTEMPLATE  on CRMBBPAYTEMPLATE.ID = BBET.TEMPLATEID 
      inner join dbo.CRMBBENVIRONMENT E on BBET.ENVIRONMENTID = E.ID and E.ISACTIVE = 1
where 
    ((@TEMPLATEID is null) or (BBET.[ID] = @TEMPLATEID)) 
    and ((NULL is null) or (CRMBBPAYTEMPLATE.[CLIENTSITESID] = NULL))