V_SITEPAGES_ALL
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 | |
| InTrashBin | bit |
Definition
Copy
create view dbo.V_SITEPAGES_ALL 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, tplt.Description AS TemplateDescription,
(CASE WHEN tplt.[UpdateDate] >= spg.[UpdateDate] THEN spg.[UpdateDate] ELSE spg.[UpdateDate] END) AS UpdateDate, spg.IsPageModel, spg.FromModelId,
COALESCE (PM.LOCKARTIFACTS, 0) AS Locked, spg.IsThemed, spg.ThemeLayoutNumber, spg.InTrashBin
FROM dbo.SitePages AS spg LEFT OUTER JOIN
dbo.SitePages AS tplt ON spg.TemplatePageID = tplt.ID LEFT OUTER JOIN
dbo.SiteLayouts AS spglyt ON spg.TemplateID = spglyt.ID LEFT OUTER JOIN
dbo.SiteLayouts AS tpltlyt ON tplt.TemplateID = tpltlyt.ID LEFT OUTER JOIN
(SELECT dbo.PAGEMODELITEM.OBJECTGUID, dbo.PAGEMODEL.LOCKARTIFACTS
FROM dbo.PAGEMODEL INNER JOIN
dbo.PAGEMODELITEM ON dbo.PAGEMODEL.ID = dbo.PAGEMODELITEM.PAGEMODELID) AS PM ON PM.OBJECTGUID = spg.Guid