vwSiteContent
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].[vwSiteContent]
as
select A.* from
(
select * from [dbo].[V_ALLCMSSITECONTENT]
) A
inner join dbo.SiteContent SC on SC.ID = A.ID
left join dbo.INSTALLEDPRODUCTLIST ipl on A.Flag = convert(nvarchar(36), ipl.ID)
where SC.deleted = 0 and (A.Flag is null or (ipl.EXPIREDATE = '' or convert(date, ipl.EXPIREDATE) > getdate()))