vwSitePagesTab
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 |
Definition
Copy
CREATE view dbo.vwSitePagesTab
as
select distinct vwSitePagesList.id, vwSitePagesList.PageName + COALESCE(' - ' + ctt.text,'') as [PageName],
COALESCE(ctt.tab, 0) as [TabId],Category, TemplatePageId, TemplatePageName, IsTemplatePage, vwSitePagesList.OwnerID,
vwSitePagesList.ClientSitesID, vwSitePagesList.Deleted, vwSitePagesList.Guid, vwSitePagesList.FolderId, vwSitePagesList.TemplateLayoutName
from vwSitePagesList
left join PageContent pg on vwSitePagesList.id = pg.SitePagesId
left join SiteContent sc on sc.id = pg.SiteContentID
left join ContentTabs ctt on sc.contentTypesID = ctt.ContentTypesID