vwContentTypes
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| Name | nvarchar(141) | yes | |
| DesktopSrc | nvarchar(256) | ||
| EditControl | nvarchar(256) | yes | |
| ClassName | nvarchar(256) | yes | |
| Static | bit | ||
| RequiresSSL | bit | yes | |
| Custom | bit | yes | |
| CustomPD | bit | ||
| UniqueContent | bit | ||
| CanCopy | bit | ||
| RealmTypeId | int | ||
| VersioningSupported | bit | ||
| Hidden | bit | ||
| Deprecated | bit | ||
| Description | nvarchar(500) | yes | |
| SupportsLimitedConnectivity | bit | yes | |
| Flag | nvarchar(50) | yes | |
| CanShare | bit | ||
| CanUpdate | bit |
Definition
Copy
CREATE VIEW [dbo].[vwContentTypes]
AS
select A.* from
(
select * from [dbo].[V_ALLCMSCONTENTTYPES]
) A
left join dbo.INSTALLEDPRODUCTLIST ipl on A.Flag = convert(nvarchar(36), ipl.ID)
where A.Flag is null or (ipl.EXPIREDATE = '' or convert(date, ipl.EXPIREDATE) > getdate())