V_INSTALLED_DATALISTCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(60) | ||
| DESCRIPTION | nvarchar(1000) | ||
| IMPLEMENTATIONTYPE | tinyint | ||
| IMPLEMENTATIONTYPENAME | varchar(3) | ||
| PROCEDURENAME | nvarchar(128) | ||
| ASSEMBLYNAME | nvarchar(128) | ||
| CLASSNAME | nvarchar(128) | ||
| RECORDTYPEID | uniqueidentifier | yes | |
| CONTEXTPARAMETERNAME | nvarchar(128) | ||
| PARAMETERDEFINITION | xml | yes | |
| RSSFEEDDEFINITION | xml | yes | |
| STATICPARAMETERDEFINITION | xml | yes | |
| OUTPUTDEFINITION | xml | ||
| DATALISTSPEC | xml | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| TASKREMINDERDEFINITION | xml | yes | |
| SPECUINAME | nvarchar(60) | ||
| UINAME | nvarchar(60) |
Definition
Copy
CREATE view dbo.V_INSTALLED_DATALISTCATALOG as
select
DATALISTCATALOG.ID,
DATALISTCATALOG.NAME,
DATALISTCATALOG.DESCRIPTION,
DATALISTCATALOG.IMPLEMENTATIONTYPE,
DATALISTCATALOG.IMPLEMENTATIONTYPENAME,
DATALISTCATALOG.PROCEDURENAME,
DATALISTCATALOG.ASSEMBLYNAME,
DATALISTCATALOG.CLASSNAME,
DATALISTCATALOG.RECORDTYPEID,
DATALISTCATALOG.CONTEXTPARAMETERNAME,
DATALISTCATALOG.PARAMETERDEFINITION,
DATALISTCATALOG.RSSFEEDDEFINITION,
DATALISTCATALOG.STATICPARAMETERDEFINITION,
DATALISTCATALOG.OUTPUTDEFINITION,
DATALISTCATALOG.DATALISTSPEC,
DATALISTCATALOG.SECURITYUIFOLDER,
DATALISTCATALOG.ADDEDBYID,
DATALISTCATALOG.CHANGEDBYID,
DATALISTCATALOG.DATEADDED,
DATALISTCATALOG.DATECHANGED,
DATALISTCATALOG.TS,
DATALISTCATALOG.TSLONG,
DATALISTCATALOG.TASKREMINDERDEFINITION,
DATALISTCATALOG.SPECUINAME,
DATALISTCATALOG.UINAME
from
dbo.DATALISTCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = DATALISTCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 2
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1