USP_DATALIST_THEMES_IN_SITE

Returns all of the Themes defined in the specified Site.

Parameters

Parameter	Parameter Type	Mode	Description
@ClientSitesId	int	IN
@INCLUDELOCKED	int	IN	Include Locked

Definition

Copy



CREATE procedure dbo.USP_DATALIST_THEMES_IN_SITE(@ClientSitesId int, @INCLUDELOCKED  int)
as
    set nocount on;

    select 
      t.ID, 
      t.NAME, 
      t.DESCRIPTION, 
      t.LAYOUTID, 
      t.TEMPLATEID, 
      t.IMAGEID, 
      t.CLIENTSITESID,
      pm.ID PAGEMODELID,
      pm.MODELNAME,
      pm.LOCKARTIFACTS
  from dbo.THEME t 
    left outer join dbo.PAGEMODELITEM pmi
    on t.ID=pmi.OBJECTGUID
    left outer join dbo.PAGEMODEL pm
    on pmi.PAGEMODELID=pm.ID
    where t.CLIENTSITESID=@ClientSitesId    
    and ((coalesce(pm.LOCKARTIFACTS,0)=0) or (@INCLUDELOCKED=1))