vwSitePagesList
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 |
Definition
Copy
CREATE VIEW [dbo].[vwSitePagesList]
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
FROM dbo.SitePages pgs
LEFT OUTER JOIN dbo.SitePages TemplatePages on pgs.TemplatePageID = TemplatePages.ID
LEFT OUTER JOIN dbo.SiteLayouts lts2 ON pgs.TemplateID = lts2.ID
LEFT OUTER JOIN dbo.SiteLayouts lts ON lts.ID = TemplatePages.TemplateID
WHERE (pgs.Deleted = 0)