vwSitePages
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| CLIENTSITESID | int | ||
| PAGENAME | nvarchar(255) | ||
| DISPLAYNAME | nvarchar(255) | yes | |
| ISADMIN | bit | ||
| BASEURL | nvarchar(50) | ||
| EXPIREDATE | datetime | yes | |
| PUBLISHDATE | datetime | yes | |
| GUID | uniqueidentifier | yes | |
| OWNERID | int | yes | |
| DELETED | bit | ||
| TEMPLATEPAGEID | int | yes | |
| ISTEMPLATEPAGE | bit | ||
| CATEGORY | nvarchar(256) | yes | |
| LayoutName | nvarchar(255) | yes | |
| TemplatePageName | nvarchar(255) | yes | |
| LayoutID | int | yes | |
| TemplateLayoutName | nvarchar(255) | yes | |
| TemplateLayoutID | int | ||
| TemplateGUID | uniqueidentifier | yes | |
| FOLDERID | int | ||
| PageLayoutStyleSheet | int | yes | |
| TemplateLayoutStyleSheet | int | yes | |
| STYLESHEETID | int | yes | |
| DESCRIPTION | nvarchar(255) | yes | |
| PageKeywords | nvarchar(255) | yes | |
| TemplateKeywords | nvarchar(255) | yes | |
| UseTemplateKeywords | bit | ||
| TemplateDescription | nvarchar(255) | yes | |
| UPDATEDATE | datetime | ||
| ISPAGEMODEL | bit | yes | |
| FROMMODELID | int | yes | |
| Locked | int | yes | |
| ISTHEMED | bit | yes | |
| THEMELAYOUTNUMBER | int | yes | |
| URL | nvarchar(255) | yes |
Definition
Copy
CREATE VIEW [dbo].[vwSitePages]
AS
SELECT
spg.ID,
spg.CLIENTSITESID,
spg.PAGENAME,
spg.DISPLAYNAME,
spg.ISADMIN,
spg.BASEURL,
spg.EXPIREDATE,
spg.PUBLISHDATE,
spg.GUID,
spg.OWNERID,
spg.DELETED,
spg.TEMPLATEPAGEID,
spg.ISTEMPLATEPAGE,
spg.CATEGORY,
tpltlyt.NAME AS LayoutName,
tplt.PAGENAME AS TemplatePageName,
tplt.TEMPLATEID AS LayoutID,
spglyt.NAME AS TemplateLayoutName,
spg.TEMPLATEID AS TemplateLayoutID,
tplt.GUID as TemplateGUID,
spg.FOLDERID,
tpltlyt.STYLESHEETID as PageLayoutStyleSheet,
spglyt.STYLESHEETID as TemplateLayoutStyleSheet,
spg.STYLESHEETID,
spg.DESCRIPTION,
spg.KEYWORDS AS PageKeywords,
tplt.KEYWORDS AS TemplateKeywords,
spg.USETEMPLATEKEYWORDS AS UseTemplateKeywords,
tplt.DESCRIPTION AS TemplateDescription,
[UPDATEDATE] = (
CASE
WHEN tplt.[UPDATEDATE] >= spg.[UPDATEDATE]
THEN spg.[UPDATEDATE]
ELSE spg.[UPDATEDATE]
END
),
spg.ISPAGEMODEL,
spg.FROMMODELID,
COALESCE(PM.LOCKARTIFACTS,0) as Locked,
spg.ISTHEMED,
spg.THEMELAYOUTNUMBER,
spg.URL
FROM dbo.SitePages spg LEFT OUTER JOIN
dbo.SitePages tplt ON spg.TEMPLATEPAGEID = tplt.ID LEFT OUTER JOIN
dbo.SiteLayouts spglyt ON spg.TEMPLATEID = spglyt.ID LEFT OUTER JOIN
dbo.SiteLayouts tpltlyt ON tplt.TEMPLATEID = tpltlyt.ID
LEFT OUTER JOIN (SELECT PAGEMODELITEM.OBJECTGUID, PAGEMODEL.LOCKARTIFACTS FROM dbo.PAGEMODEL INNER JOIN dbo.PAGEMODELITEM ON PAGEMODEL.ID = PAGEMODELITEM.PAGEMODELID) PM ON PM.OBJECTGUID = spg.[GUID]