V_INSTALLED_REPORTCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| DESCRIPTION | nvarchar(max) | ||
| REPORTSPECXML | xml | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| SPECUINAME | nvarchar(100) | ||
| UINAME | nvarchar(100) |
Definition
Copy
CREATE view dbo.V_INSTALLED_REPORTCATALOG as
select
REPORTCATALOG.ID,
REPORTCATALOG.NAME,
REPORTCATALOG.DESCRIPTION,
REPORTCATALOG.REPORTSPECXML,
REPORTCATALOG.ADDEDBYID,
REPORTCATALOG.CHANGEDBYID,
REPORTCATALOG.DATEADDED,
REPORTCATALOG.DATECHANGED,
REPORTCATALOG.TS,
REPORTCATALOG.TSLONG,
REPORTCATALOG.SPECUINAME,
REPORTCATALOG.UINAME
from
dbo.REPORTCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = REPORTCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 9
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1