V_INSTALLED_RECORDOPERATIONCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| PROCEDURENAME | nvarchar(128) | ||
| DISPLAYNAME | nvarchar(60) | ||
| RECORDOPERATIONSPECXML | xml | ||
| EXCEPTIONSXML | xml | yes | |
| DESCRIPTION | nvarchar(1000) | ||
| IMPLEMENTATIONTYPE | tinyint | ||
| IMPLEMENTATIONTYPENAME | varchar(3) | ||
| ASSEMBLYNAME | nvarchar(128) | ||
| CLASSNAME | nvarchar(128) | ||
| STATICPARAMETERDEFINITION | xml | yes | |
| RECORDTYPEID | uniqueidentifier | yes | |
| OPERATIONTYPE | tinyint | ||
| OPERATIONTYPENAME | varchar(6) | ||
| TIMEOUTSECONDS | int | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| SPECUINAME | nvarchar(60) | ||
| UINAME | nvarchar(60) |
Definition
Copy
CREATE view dbo.V_INSTALLED_RECORDOPERATIONCATALOG as
select
RECORDOPERATIONCATALOG.ID,
RECORDOPERATIONCATALOG.PROCEDURENAME,
RECORDOPERATIONCATALOG.DISPLAYNAME,
RECORDOPERATIONCATALOG.RECORDOPERATIONSPECXML,
RECORDOPERATIONCATALOG.EXCEPTIONSXML,
RECORDOPERATIONCATALOG.DESCRIPTION,
RECORDOPERATIONCATALOG.IMPLEMENTATIONTYPE,
RECORDOPERATIONCATALOG.IMPLEMENTATIONTYPENAME,
RECORDOPERATIONCATALOG.ASSEMBLYNAME,
RECORDOPERATIONCATALOG.CLASSNAME,
RECORDOPERATIONCATALOG.STATICPARAMETERDEFINITION,
RECORDOPERATIONCATALOG.RECORDTYPEID,
RECORDOPERATIONCATALOG.OPERATIONTYPE,
RECORDOPERATIONCATALOG.OPERATIONTYPENAME,
RECORDOPERATIONCATALOG.TIMEOUTSECONDS,
RECORDOPERATIONCATALOG.SECURITYUIFOLDER,
RECORDOPERATIONCATALOG.ADDEDBYID,
RECORDOPERATIONCATALOG.CHANGEDBYID,
RECORDOPERATIONCATALOG.DATEADDED,
RECORDOPERATIONCATALOG.DATECHANGED,
RECORDOPERATIONCATALOG.TS,
RECORDOPERATIONCATALOG.TSLONG,
RECORDOPERATIONCATALOG.SPECUINAME,
RECORDOPERATIONCATALOG.UINAME
from
dbo.RECORDOPERATIONCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = RECORDOPERATIONCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 23
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1