V_INSTALLED_DASHBOARDCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(60) | ||
| DESCRIPTION | nvarchar(1000) | ||
| SPECXML | xml | ||
| CONTEXTRECORDTYPEID | uniqueidentifier | yes | |
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| TS | timestamp | ||
| TSLONG | bigint | yes |
Definition
Copy
CREATE view dbo.V_INSTALLED_DASHBOARDCATALOG as
select
DASHBOARDCATALOG.ID,
DASHBOARDCATALOG.NAME,
DASHBOARDCATALOG.DESCRIPTION,
DASHBOARDCATALOG.SPECXML,
DASHBOARDCATALOG.CONTEXTRECORDTYPEID,
DASHBOARDCATALOG.ADDEDBYID,
DASHBOARDCATALOG.CHANGEDBYID,
DASHBOARDCATALOG.DATEADDED,
DASHBOARDCATALOG.DATECHANGED,
DASHBOARDCATALOG.SECURITYUIFOLDER,
DASHBOARDCATALOG.TS,
DASHBOARDCATALOG.TSLONG
from
dbo.DASHBOARDCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = DASHBOARDCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 24
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1