vwPageContent
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| Title | nvarchar(256) | yes | |
| Description | nvarchar(256) | yes | |
| XMLData | ntext | yes | |
| ContentExpireDate | datetime | yes | |
| ContentPublishDate | datetime | yes | |
| CacheTime | int | yes | |
| Guid | uniqueidentifier | ||
| OwnerID | int | yes | |
| Approved | bit | ||
| ContentTypesID | int | yes | |
| ClientSitesID | int | ||
| IsTimePublished | bit | ||
| LanguageTarget | nvarchar(256) | yes | |
| WorkflowID | int | yes | |
| TestMode | bit | ||
| FromModelId | int | yes | |
| FolderID | int | ||
| TypeName | nvarchar(141) | yes | |
| DesktopSrc | nvarchar(256) | ||
| EditControl | nvarchar(256) | yes | |
| ClassName | nvarchar(256) | yes | |
| Static | bit | ||
| MustUseSSL | bit | yes | |
| Custom | bit | yes | |
| CustomPD | bit | ||
| UniqueContent | bit | ||
| CanCopy | bit | ||
| RealmTypeId | int | ||
| Owner | nvarchar(50) | yes | |
| CreateDate | datetime | ||
| Discoverable | bit | ||
| DiscoverableTitle | nvarchar(255) | yes | |
| DiscoverableSummary | nvarchar(4000) | yes | |
| UpdateDate | datetime | ||
| SiteContentVersionID | int | yes | |
| Status | int | ||
| StatusUpdatedOn | datetime | yes | |
| StatusUpdatedBy | int | yes | |
| StatusUpdatedByName | nvarchar(50) | yes | |
| Comments | nvarchar(256) | yes | |
| SupportsLimitedConnectivity | bit | yes | |
| Flag | nvarchar(50) | yes | |
| CanUpdate | bit | ||
| CanShare | bit | ||
| ShareInSiteCopy | bit | ||
| CanCreateLocalCopy | bit | ||
| ChangedByCMSUserID | int | yes | |
| BBSPEnabled | bit | ||
| ContentOrder | int | ||
| PaneName | nvarchar(256) | yes | |
| PageContentID | int | ||
| RequiresSSL | bit | yes | |
| PageID | int | ||
| PageName | nvarchar(255) | ||
| IsAdmin | bit | ||
| BaseURL | nvarchar(50) | ||
| ExpireDate | datetime | yes | |
| PublishDate | datetime | yes | |
| TemplateID | int | ||
| PageGuid | uniqueidentifier | yes | |
| PageOwnerID | int | yes | |
| IsTemplatePage | bit | ||
| DisplayName | nvarchar(255) | yes |
Definition
Copy
CREATE view [dbo].[vwPageContent]
as
select top 100 percent
vwCnt.ID, vwCnt.Title, vwCnt.Description, vwCnt.XMLData, vwCnt.ContentExpireDate,
vwCnt.ContentPublishDate, vwCnt.CacheTime, vwCnt.Guid, vwCnt.OwnerID, vwCnt.Approved, vwCnt.ContentTypesID, vwCnt.ClientSitesID, vwCnt.IsTimePublished,
vwCnt.LanguageTarget, vwCnt.WorkflowID, vwCnt.TestMode, vwCnt.FromModelId, vwCnt.FolderID, vwCnt.TypeName, vwCnt.DesktopSrc, vwCnt.EditControl, vwCnt.ClassName, vwCnt.Static,
vwCnt.MustUseSSL, vwCnt.Custom, vwCnt.CustomPD, vwCnt.UniqueContent, vwCnt.CanCopy, vwCnt.RealmTypeId, vwCnt.Owner, vwCnt.CreateDate,
vwCnt.Discoverable, vwCnt.DiscoverableTitle, vwCnt.DiscoverableSummary, vwCnt.UpdateDate, vwCnt.SiteContentVersionID, vwCnt.Status,
vwCnt.StatusUpdatedOn, vwCnt.StatusUpdatedBy,vwCnt.StatusUpdatedByName, vwCnt.Comments, vwCnt.SupportsLimitedConnectivity, vwCnt.Flag,
vwCnt.CanUpdate, vwCnt.CanShare, vwCnt.ShareInSiteCopy, vwCnt.CanCreateLocalCopy, vwCnt.ChangedByCMSUserID, vwCnt.BBSPEnabled,
pgct.ContentOrder,
pgct.PaneName,
pgct.ID AS PageContentID,
pgct.RequiresSSL,
spgs.ID AS PageID,
spgs.PageName,
spgs.IsAdmin,
spgs.BaseURL,
spgs.ExpireDate,
spgs.PublishDate,
spgs.TemplateID,
spgs.Guid AS PageGuid,
spgs.OwnerID AS PageOwnerID,
spgs.IsTemplatePage,
spgs.DisplayName
from
dbo.SitePages spgs
inner join dbo.PageContent pgct on spgs.ID=pgct.SitePagesID
inner join dbo.vwSiteContent vwCnt on vwCnt.id = pgct.SiteContentID
where
spgs.Deleted = 0
order by
spgs.ID,
pgct.PaneName,
pgct.ContentOrder