V_INSTALLED_SMARTFIELDCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| PROCEDURENAME | nvarchar(128) | ||
| DESCRIPTION | nvarchar(max) | ||
| SMARTFIELDSPECXML | xml | ||
| FORMMETADATAXML | xml | yes | |
| DATATYPECODE | tinyint | ||
| RECORDTYPEID | uniqueidentifier | ||
| DISPLAYNAME | nvarchar(100) | ||
| SMARTFIELDFOLDER | nvarchar(500) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| DATATYPE | nvarchar(7) | yes | |
| VALUERECORDTYPEID | uniqueidentifier | yes | |
| HASSITEFILTER | bit |
Definition
Copy
CREATE view dbo.V_INSTALLED_SMARTFIELDCATALOG as
with xmlnamespaces ('bb_appfx_commontypes' as common)
select
ID,
PROCEDURENAME,
DESCRIPTION,
SMARTFIELDSPECXML,
FORMMETADATAXML,
DATATYPECODE,
RECORDTYPEID,
DISPLAYNAME,
SMARTFIELDFOLDER,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED,
TS,
TSLONG,
DATATYPE,
VALUERECORDTYPEID,
HASSITEFILTER
from
dbo.SMARTFIELDCATALOG
where
case when SMARTFIELDSPECXML.exist('(/*/common:InstalledProductList)[1]/common:InstalledProduct/@ID') = 0 then 1
else
[dbo].[UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED](
SMARTFIELDSPECXML.query(
'declare namespace common="bb_appfx_commontypes";
/*/common:InstalledProductList'
)
)
end = 1