V_ALLCMSSITECONTENT
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 |
Definition
Copy
CREATE view [dbo].[V_ALLCMSSITECONTENT]
as
select scnt.ID, scnt.Title, scnt.Description, ISNULL(scv.XMLData, scnt.XMLData) AS XMLData, scnt.ExpireDate AS ContentExpireDate,
scnt.PublishDate AS ContentPublishDate, scnt.CacheTime, scnt.Guid, scnt.OwnerID, scnt.Approved, scnt.ContentTypesID, scnt.ClientSitesID, scnt.IsTimePublished,
scnt.LanguageTarget, scnt.WorkflowID, scnt.TestMode, scnt.FromModelId, scnt.FolderID, atyp.Name AS TypeName, atyp.DesktopSrc, atyp.EditControl, atyp.ClassName, atyp.Static,
atyp.RequiresSSL AS MustUseSSL, atyp.Custom, atyp.CustomPD, atyp.UniqueContent, atyp.CanCopy, atyp.RealmTypeId, cusr.UserName AS Owner, scnt.CreateDate,
scnt.Discoverable, scnt.DiscoverableTitle, scnt.DiscoverableSummary, scnt.UpdateDate, scv.ID AS SiteContentVersionID, ISNULL(scv.Status, 2) AS Status,
scv.StatusUpdatedOn, scv.StatusUpdatedBy, cusr2.UserName AS StatusUpdatedByName, scv.Comments, atyp.SupportsLimitedConnectivity, atyp.Flag,
atyp.CanUpdate, atyp.CanShare, scnt.ShareInSiteCopy, scnt.CanCreateLocalCopy, scnt.ChangedByCMSUserID, scnt.BBSPEnabled
from dbo.SiteContent AS scnt INNER JOIN
dbo.V_ALLCMSCONTENTTYPES AS atyp ON scnt.ContentTypesID = atyp.ID LEFT OUTER JOIN
dbo.ClientUsers AS cusr ON scnt.OwnerID = cusr.ID LEFT OUTER JOIN
dbo.SiteContentVersion AS scv ON scv.SiteContentID = scnt.ID LEFT OUTER JOIN
dbo.ClientUsers AS cusr2 ON scv.StatusUpdatedBy = cusr2.ID