V_INSTALLED_SMARTQUERYCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(60) | ||
| DESCRIPTION | nvarchar(1000) | ||
| TVFNAME | nvarchar(128) | ||
| TVFPARAMETERLIST | nvarchar(1000) | yes | |
| RECORDTYPEID | uniqueidentifier | ||
| FILTERFORMDEFINITION | xml | ||
| OUTPUTDEFINITION | xml | ||
| STATICPARAMETERDEFINITION | xml | yes | |
| PRIMARYKEYFIELD | nvarchar(128) | yes | |
| SMARTQUERYSPEC | xml | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| HASAPPUSERIDPARAM | bit | ||
| 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_SMARTQUERYCATALOG as
select
SMARTQUERYCATALOG.ID,
SMARTQUERYCATALOG.NAME,
SMARTQUERYCATALOG.DESCRIPTION,
SMARTQUERYCATALOG.TVFNAME,
SMARTQUERYCATALOG.TVFPARAMETERLIST,
SMARTQUERYCATALOG.RECORDTYPEID,
SMARTQUERYCATALOG.FILTERFORMDEFINITION,
SMARTQUERYCATALOG.OUTPUTDEFINITION,
SMARTQUERYCATALOG.STATICPARAMETERDEFINITION,
SMARTQUERYCATALOG.PRIMARYKEYFIELD,
SMARTQUERYCATALOG.SMARTQUERYSPEC,
SMARTQUERYCATALOG.SECURITYUIFOLDER,
SMARTQUERYCATALOG.HASAPPUSERIDPARAM,
SMARTQUERYCATALOG.ADDEDBYID,
SMARTQUERYCATALOG.CHANGEDBYID,
SMARTQUERYCATALOG.DATEADDED,
SMARTQUERYCATALOG.DATECHANGED,
SMARTQUERYCATALOG.TS,
SMARTQUERYCATALOG.TSLONG,
SMARTQUERYCATALOG.SPECUINAME,
SMARTQUERYCATALOG.UINAME
from
dbo.SMARTQUERYCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = SMARTQUERYCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 12
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1