V_SITEPAGESTAB_ALL
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| PageName | nvarchar(308) | yes | |
| TabId | int | yes | |
| Category | nvarchar(256) | yes | |
| TemplatePageID | int | yes | |
| TemplatePageName | nvarchar(255) | yes | |
| IsTemplatePage | bit | ||
| OwnerID | int | yes | |
| ClientSitesID | int | ||
| Deleted | bit | ||
| Guid | uniqueidentifier | yes | |
| FolderID | int | ||
| TemplateLayoutName | nvarchar(255) | yes | |
| InTrashBin | bit | ||
| DISPLAYNAME | nvarchar(255) | yes | |
| URL | nvarchar(255) | yes | |
| UpdateDate | datetime |
Definition
Copy
CREATE view [dbo].[V_SITEPAGESTAB_ALL] as
SELECT DISTINCT
dbo.v_SitePagesList_All.ID, dbo.v_SitePagesList_All.PageName + COALESCE (' - ' + ctt.Text, '') AS PageName, COALESCE (ctt.Tab, 0) AS TabId,
dbo.v_SitePagesList_All.Category, dbo.v_SitePagesList_All.TemplatePageID, dbo.v_SitePagesList_All.TemplatePageName, dbo.v_SitePagesList_All.IsTemplatePage,
dbo.v_SitePagesList_All.OwnerID, dbo.v_SitePagesList_All.ClientSitesID, dbo.v_SitePagesList_All.Deleted, dbo.v_SitePagesList_All.Guid, dbo.v_SitePagesList_All.FolderID,
dbo.v_SitePagesList_All.TemplateLayoutName, dbo.v_SitePagesList_All.InTrashBin, dbo.v_SitePagesList_All.DISPLAYNAME, dbo.v_SitePagesList_All.URL, dbo.v_SitePagesList_All.UpdateDate
FROM dbo.v_SitePagesList_All LEFT OUTER JOIN
dbo.PageContent AS pg ON dbo.v_SitePagesList_All.ID = pg.SitePagesID LEFT OUTER JOIN
dbo.SiteContent AS sc ON sc.ID = pg.SiteContentID LEFT OUTER JOIN
dbo.ContentTabs AS ctt ON sc.ContentTypesID = ctt.ContentTypesID