USP_DATALIST_CMSPARTS
Returns a list of parts from the CMS.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTENTTYPEID | int | IN | Content Type ID |
| @CLIENTSITEID | int | IN | Client Site ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_CMSPARTS(@CONTENTTYPEID int = 0, @CLIENTSITEID int = 0)
as
set nocount on;
select SC.ID, SC.Guid, SC.Title
from dbo.SiteContent SC
left outer join dbo.PAGEMODELITEM PMI on PMI.OBJECTGUID = SC.Guid
left outer join (select * from dbo.PAGEMODEL where LOCKARTIFACTS = 1) PM on PM.ID = PMI.PAGEMODELID
where PM.LOCKARTIFACTS is null
and SC.Deleted = 0
and (@CONTENTTYPEID = 0 OR SC.ContentTypesID = @CONTENTTYPEID)
and (@CLIENTSITEID = 0 OR SC.ClientSitesID = @CLIENTSITEID)
order by SC.Title