V_INSTALLED_QUERYVIEWCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| OBJECTNAME | nvarchar(128) | ||
| DISPLAYNAME | nvarchar(255) | ||
| RECORDTYPEID | uniqueidentifier | yes | |
| OBJECTTYPE | tinyint | ||
| OBJECTTYPENAME | varchar(20) | ||
| ROOTOBJECT | bit | ||
| ENFORCERECORDACCESSSECURITY | bit | ||
| DESCRIPTION | nvarchar(max) | ||
| PRIMARYKEYFIELD | nvarchar(128) | yes | |
| PRIMARYKEYTYPENAME | nvarchar(128) | yes | |
| SUBGROUP | nvarchar(255) | ||
| OUTPUTDEFINITIONXML | xml | yes | |
| PARAMETERMETADATAXML | xml | yes | |
| QUERYVIEWSPEC | xml | yes | |
| QUERYVIEWSPECEXTENSION | xml | yes | |
| SECURITYUIFOLDER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| USEINREPORTMODELGENERATOR | bit |
Definition
Copy
CREATE view dbo.V_INSTALLED_QUERYVIEWCATALOG as
select
QUERYVIEWCATALOG.ID,
QUERYVIEWCATALOG.OBJECTNAME,
QUERYVIEWCATALOG.DISPLAYNAME,
QUERYVIEWCATALOG.RECORDTYPEID,
QUERYVIEWCATALOG.OBJECTTYPE,
QUERYVIEWCATALOG.OBJECTTYPENAME,
QUERYVIEWCATALOG.ROOTOBJECT,
QUERYVIEWCATALOG.ENFORCERECORDACCESSSECURITY,
QUERYVIEWCATALOG.DESCRIPTION,
QUERYVIEWCATALOG.PRIMARYKEYFIELD,
QUERYVIEWCATALOG.PRIMARYKEYTYPENAME,
QUERYVIEWCATALOG.SUBGROUP,
QUERYVIEWCATALOG.OUTPUTDEFINITIONXML,
QUERYVIEWCATALOG.PARAMETERMETADATAXML,
QUERYVIEWCATALOG.QUERYVIEWSPEC,
QUERYVIEWCATALOG.QUERYVIEWSPECEXTENSION,
QUERYVIEWCATALOG.SECURITYUIFOLDER,
QUERYVIEWCATALOG.ADDEDBYID,
QUERYVIEWCATALOG.CHANGEDBYID,
QUERYVIEWCATALOG.DATEADDED,
QUERYVIEWCATALOG.DATECHANGED,
QUERYVIEWCATALOG.TS,
QUERYVIEWCATALOG.TSLONG,
QUERYVIEWCATALOG.USEINREPORTMODELGENERATOR
from
dbo.QUERYVIEWCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = QUERYVIEWCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 7
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1