V_INSTALLED_SEARCHLISTCATALOG
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 | ||
| FILTERFORMDEFINITION | xml | ||
| OUTPUTDEFINITION | xml | ||
| STATICPARAMETERDEFINITION | xml | yes | |
| SEARCHLISTSPEC | xml | ||
| TRANSLATIONFUNCTIONCATALOGID | uniqueidentifier | ||
| QUICKFINDFIELD | nvarchar(128) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| SECURITYUIFOLDER | nvarchar(255) | ||
| SPECUINAME | nvarchar(60) | ||
| UINAME | nvarchar(60) |
Definition
Copy
CREATE view dbo.V_INSTALLED_SEARCHLISTCATALOG as
select
SEARCHLISTCATALOG.ID,
SEARCHLISTCATALOG.NAME,
SEARCHLISTCATALOG.DESCRIPTION,
SEARCHLISTCATALOG.IMPLEMENTATIONTYPE,
SEARCHLISTCATALOG.IMPLEMENTATIONTYPENAME,
SEARCHLISTCATALOG.PROCEDURENAME,
SEARCHLISTCATALOG.ASSEMBLYNAME,
SEARCHLISTCATALOG.CLASSNAME,
SEARCHLISTCATALOG.RECORDTYPEID,
SEARCHLISTCATALOG.FILTERFORMDEFINITION,
SEARCHLISTCATALOG.OUTPUTDEFINITION,
SEARCHLISTCATALOG.STATICPARAMETERDEFINITION,
SEARCHLISTCATALOG.SEARCHLISTSPEC,
SEARCHLISTCATALOG.TRANSLATIONFUNCTIONCATALOGID,
SEARCHLISTCATALOG.QUICKFINDFIELD,
SEARCHLISTCATALOG.ADDEDBYID,
SEARCHLISTCATALOG.CHANGEDBYID,
SEARCHLISTCATALOG.DATEADDED,
SEARCHLISTCATALOG.DATECHANGED,
SEARCHLISTCATALOG.TS,
SEARCHLISTCATALOG.TSLONG,
SEARCHLISTCATALOG.SECURITYUIFOLDER,
SEARCHLISTCATALOG.SPECUINAME,
SEARCHLISTCATALOG.UINAME
from
dbo.SEARCHLISTCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = SEARCHLISTCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 10
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1