USP_DATALIST_xxx

Finds Site Content on a particular page.

Parameters

Parameter	Parameter Type	Mode	Description
@PageID	int	IN	Input parameter indicating the context ID for the data list.
@ContentTypesID	int	IN	Content Types ID

Definition

Copy



        create procedure dbo.USP_DATALIST_xxx
        (
            @PageID int
          , @ContentTypesID int = null
        )
        as
            set nocount on;

          select 
            SC.Guid
          , SC.ContentTypesID
          from 
            dbo.SiteContent as SC 
          inner join 
            dbo.PageContent as PC
          on 
            SC.ID = PC.SiteContentID 
          where 
            PC.SitePagesID = @PageID and
            ((@ContentTypesID IS NULL) OR (SC.ContentTypesID = @ContentTypesID))