V_INSTALLED_DATAFORMTEMPLATECATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| TEMPLATENAME | nvarchar(60) | ||
| DESCRIPTION | nvarchar(1000) | ||
| RECORDTYPEID | uniqueidentifier | yes | |
| MODE | smallint | ||
| MODENAME | varchar(4) | ||
| IMPLEMENTATIONTYPE | tinyint | ||
| IMPLEMENTATIONTYPENAME | varchar(3) | ||
| LOADPROCEDURE | nvarchar(128) | ||
| SAVEPROCEDURE | nvarchar(128) | ||
| ASSEMBLYNAME | nvarchar(128) | ||
| CLASSNAME | nvarchar(128) | ||
| FORMDEFINITIONXML | xml | ||
| STATICPARAMETERDEFINITION | xml | yes | |
| EXCEPTIONSXML | xml | yes | |
| TEMPLATESPECXML | xml | ||
| CONTEXTRECORDTYPEID | uniqueidentifier | yes | |
| CONTEXTPARAMETERNAME | nvarchar(128) | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| HASTSLONG | bit | ||
| HASAPPUSERFORLOAD | bit | ||
| HASAPPUSERFORSAVE | bit | ||
| HASIDFORLOAD | bit | ||
| HASCHANGEAGENT | bit | ||
| NOSECURITYREQUIRED | bit | ||
| SPECUINAME | nvarchar(60) | ||
| UINAME | nvarchar(60) | ||
| SECURITYUIDISPLAYFEATURE | bit |
Definition
Copy
CREATE view dbo.V_INSTALLED_DATAFORMTEMPLATECATALOG as
select
DATAFORMTEMPLATECATALOG.ID,
DATAFORMTEMPLATECATALOG.TEMPLATENAME,
DATAFORMTEMPLATECATALOG.DESCRIPTION,
DATAFORMTEMPLATECATALOG.RECORDTYPEID,
DATAFORMTEMPLATECATALOG.MODE,
DATAFORMTEMPLATECATALOG.MODENAME,
DATAFORMTEMPLATECATALOG.IMPLEMENTATIONTYPE,
DATAFORMTEMPLATECATALOG.IMPLEMENTATIONTYPENAME,
DATAFORMTEMPLATECATALOG.LOADPROCEDURE,
DATAFORMTEMPLATECATALOG.SAVEPROCEDURE,
DATAFORMTEMPLATECATALOG.ASSEMBLYNAME,
DATAFORMTEMPLATECATALOG.CLASSNAME,
DATAFORMTEMPLATECATALOG.FORMDEFINITIONXML,
DATAFORMTEMPLATECATALOG.STATICPARAMETERDEFINITION,
DATAFORMTEMPLATECATALOG.EXCEPTIONSXML,
DATAFORMTEMPLATECATALOG.TEMPLATESPECXML,
DATAFORMTEMPLATECATALOG.CONTEXTRECORDTYPEID,
DATAFORMTEMPLATECATALOG.CONTEXTPARAMETERNAME,
DATAFORMTEMPLATECATALOG.SECURITYUIFOLDER,
DATAFORMTEMPLATECATALOG.ADDEDBYID,
DATAFORMTEMPLATECATALOG.CHANGEDBYID,
DATAFORMTEMPLATECATALOG.DATEADDED,
DATAFORMTEMPLATECATALOG.DATECHANGED,
DATAFORMTEMPLATECATALOG.TS,
DATAFORMTEMPLATECATALOG.TSLONG,
DATAFORMTEMPLATECATALOG.HASTSLONG,
DATAFORMTEMPLATECATALOG.HASAPPUSERFORLOAD,
DATAFORMTEMPLATECATALOG.HASAPPUSERFORSAVE,
DATAFORMTEMPLATECATALOG.HASIDFORLOAD,
DATAFORMTEMPLATECATALOG.HASCHANGEAGENT,
DATAFORMTEMPLATECATALOG.NOSECURITYREQUIRED,
DATAFORMTEMPLATECATALOG.SPECUINAME,
DATAFORMTEMPLATECATALOG.UINAME,
DATAFORMTEMPLATECATALOG.SECURITYUIDISPLAYFEATURE
from
dbo.DATAFORMTEMPLATECATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = DATAFORMTEMPLATECATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE in (0, 3, 19)
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1