V_SITEPAGESLIST_ALL
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LayoutName | nvarchar(255) | yes | |
| 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 | ||
| TemplatePageName | nvarchar(255) | yes | |
| LayoutID | int | yes | |
| TemplateLayoutName | nvarchar(255) | yes | |
| Category | nvarchar(256) | yes | |
| TemplateLayoutID | int | ||
| FolderID | int | ||
| InTrashBin | bit | ||
| URL | nvarchar(255) | yes | |
| UpdateDate | datetime |
Definition
Copy
CREATE view [dbo].[V_SITEPAGESLIST_ALL] as
SELECT lts.Name AS LayoutName, pgs.ID, pgs.ClientSitesID, pgs.PageName, pgs.DisplayName, pgs.IsAdmin, pgs.BaseURL, pgs.ExpireDate, pgs.PublishDate, pgs.Guid,
pgs.OwnerID, pgs.Deleted, pgs.TemplatePageID, pgs.IsTemplatePage, TemplatePages.PageName AS TemplatePageName, TemplatePages.TemplateID AS LayoutID,
lts2.Name AS TemplateLayoutName, pgs.Category, pgs.TemplateID AS TemplateLayoutID, pgs.FolderID, pgs.InTrashBin, pgs.URL, pgs.UpdateDate
FROM dbo.SitePages AS pgs LEFT OUTER JOIN
dbo.SitePages AS TemplatePages ON pgs.TemplatePageID = TemplatePages.ID LEFT OUTER JOIN
dbo.SiteLayouts AS lts2 ON pgs.TemplateID = lts2.ID LEFT OUTER JOIN
dbo.SiteLayouts AS lts ON lts.ID = TemplatePages.TemplateID