V_QUERY_RECORDOPERATIONPARAMETERS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDOPERATIONID | uniqueidentifier | ||
| FIELDID | nvarchar(max) | yes | |
| DATATYPE | nvarchar(max) | yes | |
| REQUIRED | int | yes | |
| READONLY | int | yes | |
| HIDDEN | int | yes | |
| MAXLENGTH | int | yes | |
| CAPTION | nvarchar(max) | yes | |
| DESCRIPTION | nvarchar(max) | yes | |
| MAXVALUE | int | yes | |
| MINVALUE | int | yes | |
| PRECISION | int | yes | |
| SCALE | int | yes | |
| TIMEPRECISION | int | yes | |
| DATETIMEWITHOFFSETPRECISION | int | yes | |
| INCLUDETIMEONDATE | int | yes | |
| ALLOWMONTHDAYONFUZZYDATE | int | yes | |
| DEFAULTVALUETEXT | nvarchar(max) | yes | |
| FIXEDVALUETEXT | nvarchar(max) | yes | |
| CAPTIONRESOURCEKEY | nvarchar(max) | yes | |
| CATEGORY | nvarchar(max) | yes | |
| CATEGORYRESOURCEKEY | nvarchar(max) | yes | |
| DONOTAPPLYFORMAT | int | yes | |
| MULTILINE | int | yes | |
| APPLYPHONEFORMATTING | int | yes | |
| ALLOWZOOM | int | yes | |
| AVAILABLETOCLIENT | int | yes | |
| DESCRIPTORTYPE | varchar(14) | ||
| INSTALLEDPRODUCTSLIST | nvarchar(max) | yes | |
| INSTALLED | bit | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:53 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECORDOPERATIONPARAMETERS AS
with xmlnamespaces ('bb_appfx_recordoperation' as tns, 'bb_appfx_commontypes' as common)
select
R.ID as RECORDOPERATIONID,
recordoperation.parameters.value('@FieldID', 'nvarchar(max)') as FIELDID,
recordoperation.parameters.value('@DataType', 'nvarchar(max)') as DATATYPE,
coalesce(recordoperation.parameters.value('@Required', 'bit'), 0) as REQUIRED,
coalesce(recordoperation.parameters.value('@ReadOnly', 'bit'), 0) as READONLY,
coalesce(recordoperation.parameters.value('@Hidden', 'bit'), 0) as HIDDEN,
coalesce(recordoperation.parameters.value('@MaxLength', 'integer'), 0) as MAXLENGTH,
recordoperation.parameters.value('@Caption', 'nvarchar(max)') as CAPTION,
recordoperation.parameters.value('@Description', 'nvarchar(max)') as DESCRIPTION,
coalesce(recordoperation.parameters.value('@MaxValue', 'integer'), 0) as MAXVALUE,
coalesce(recordoperation.parameters.value('@MinValue', 'integer'), -1) as MINVALUE,
coalesce(recordoperation.parameters.value('@PRECISION', 'integer'), -1) as PRECISION,
coalesce(recordoperation.parameters.value('@Scale', 'integer'), -1) as SCALE,
coalesce(recordoperation.parameters.value('@TimePrecision', 'integer'), 0) as TIMEPRECISION,
coalesce(recordoperation.parameters.value('@DateTimeWithOffsetPrecision', 'integer'), 3) as DATETIMEWITHOFFSETPRECISION,
coalesce(recordoperation.parameters.value('@IncludeTimeOnDate', 'bit'), 0) as INCLUDETIMEONDATE,
coalesce(recordoperation.parameters.value('@AllowMonthDayOnFuzzyDate', 'bit'), 0) as ALLOWMONTHDAYONFUZZYDATE,
recordoperation.parameters.value('@DefaultValueText', 'nvarchar(max)') as DEFAULTVALUETEXT,
recordoperation.parameters.value('@FixedValueText', 'nvarchar(max)') as FIXEDVALUETEXT,
recordoperation.parameters.value('@CaptionResourceKey', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
recordoperation.parameters.value('@Category', 'nvarchar(max)') as CATEGORY,
recordoperation.parameters.value('@CategoryResourceKey', 'nvarchar(max)') as CATEGORYRESOURCEKEY,
coalesce(recordoperation.parameters.value('@DoNotApplyFormat', 'bit'), 0) as DONOTAPPLYFORMAT,
coalesce(recordoperation.parameters.value('@Multiline', 'bit'), 0) as MULTILINE,
coalesce(recordoperation.parameters.value('@ApplyPhoneFormatting', 'bit'), 0) as APPLYPHONEFORMATTING,
coalesce(recordoperation.parameters.value('@AllowZoom', 'bit'), 0) as ALLOWZOOM,
coalesce(recordoperation.parameters.value('@AvailableToClient', 'bit'), 1) as AVAILABLETOCLIENT,
case
when recordoperation.parameters.exist('common:CodeTable') = 1 then 'CodeTable'
when recordoperation.parameters.exist('common:ValueList') = 1 then 'ValueList'
when recordoperation.parameters.exist('common:SimpleDataList') = 1 then 'SimpleDataList'
when recordoperation.parameters.exist('common:Collection') = 1 then 'Collection'
when recordoperation.parameters.exist('common:SearchList') = 1 then 'SearchList'
when recordoperation.parameters.exist('common:Link') = 1 then 'Link'
when recordoperation.parameters.exist('common:File') = 1 then 'File'
when recordoperation.parameters.exist('common:CreditCard') = 1 then 'CreditCard'
when recordoperation.parameters.exist('common:Html') = 1 then 'Html'
else 'None'
end as DESCRIPTORTYPE,
dbo.UFN_INSTALLEDPRODUCTS_TRANSLATELIST(recordoperation.parameters.query('common:InstalledProductList')) as INSTALLEDPRODUCTSLIST,
dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(recordoperation.parameters.query('common:InstalledProductList')) as INSTALLED
/*#EXTENSION*/
from dbo.RECORDOPERATIONCATALOG as R
cross apply R.RECORDOPERATIONSPECXML.nodes('tns:RecordOperationSpec/tns:Parameters/tns:FormFields/common:FormField') as recordoperation(parameters)