USP_DATALIST_CMSTEMPLATELAYOUTS

Returns the layouts associated with each delivery channel for the template.

Parameters

Parameter	Parameter Type	Mode	Description
@TEMPLATEID	int	IN	Template ID

Definition

Copy



create procedure dbo.USP_DATALIST_CMSTEMPLATELAYOUTS(@TEMPLATEID int)
as
    set nocount on;

    select 
        CMSTEMPLATELAYOUT.[CMSDELIVERYCHANNELID],
        CMSTEMPLATELAYOUT.[SITELAYOUTSID]
    from 
        dbo.CMSTEMPLATELAYOUT
    where
        CMSTEMPLATELAYOUT.[TEMPLATEID] = @TEMPLATEID