V_QUERY_DATALISTOUTPUT
Provides support for querying on the output for data lists from the application catalog.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATALISTID | uniqueidentifier | Data List ID | |
| FIELDID | nvarchar(max) | yes | Field ID |
| CAPTION | nvarchar(max) | yes | Caption |
| ISHIDDEN | int | yes | Is hidden |
| DATATYPE | nvarchar(18) | yes | Data type |
| IDCOLUMN | nvarchar(max) | yes | ID column |
| RECORDTYPE | nvarchar(max) | yes | Record type |
| ISIMAGEKEY | int | yes | Is image key |
| DISPLAYBOOLEANASCHECK | int | yes | Display boolean as check |
| DISPLAYDATEASDATETIME | int | yes | Display Date as DateTime |
| GROUPCAPTIONFIELD | nvarchar(max) | yes | Group caption field |
| CAPTIONRESOURCEKEY | nvarchar(max) | yes | Caption resource key |
| FORMAT | nvarchar(max) | yes | Format |
| TEXTALIGN | nvarchar(7) | yes | Text align |
| DISPLAYSEQUENCE | int | yes | Display sequence |
| INSTALLEDPRODUCTSLIST | nvarchar(max) | yes | Installed product list |
| INSTALLED | bit | yes | Installed |
| IMAGELINKFIELD | nvarchar(max) | yes | |
| CAPTIONSUMMARYFIELDID | nvarchar(max) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:56 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DATALISTOUTPUT AS
with xmlnamespaces ('bb_appfx_datalist' as tns, 'bb_appfx_commontypes' as common)
select
D.ID as DATALISTID,
datalistoutput.fields.value('@FieldID', 'nvarchar(max)') as FIELDID,
datalistoutput.fields.value('@Caption', 'nvarchar(max)') as CAPTION,
coalesce(datalistoutput.fields.value('@IsHidden', 'bit'), 0) as ISHIDDEN,
datalistoutput.fields.value('@DataType', 'nvarchar(18)') as DATATYPE,
datalistoutput.fields.value('@IDColumn', 'nvarchar(max)') as IDCOLUMN,
datalistoutput.fields.value('@RecordType', 'nvarchar(max)') as RECORDTYPE,
coalesce(datalistoutput.fields.value('@IsImageKey', 'bit'), 0) as ISIMAGEKEY,
coalesce(datalistoutput.fields.value('@DisplayBooleanAsCheck', 'bit'), 0) as DISPLAYBOOLEANASCHECK,
coalesce(datalistoutput.fields.value('@DisplayDateAsDateTime', 'bit'), 0) as DISPLAYDATEASDATETIME,
datalistoutput.fields.value('@GroupCaptionField', 'nvarchar(max)') as GROUPCAPTIONFIELD,
datalistoutput.fields.value('@CaptionResourceKey', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
datalistoutput.fields.value('@Format', 'nvarchar(max)') as FORMAT,
datalistoutput.fields.value('@TextAlign', 'nvarchar(7)') as TEXTALIGN,
datalistoutput.fields.value('@DisplaySequence', 'integer') as DISPLAYSEQUENCE,
dbo.UFN_INSTALLEDPRODUCTS_TRANSLATELIST(datalistoutput.fields.query('common:InstalledProductList')) as INSTALLEDPRODUCTSLIST,
dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(datalistoutput.fields.query('common:InstalledProductList')) as INSTALLED,
datalistoutput.fields.value('@ImageLinkField', 'nvarchar(max)') as IMAGELINKFIELD,
datalistoutput.fields.value('@CaptionSummaryFieldID', 'nvarchar(max)') as CAPTIONSUMMARYFIELDID
/*#EXTENSION*/
from dbo.DATALISTCATALOG as D
cross apply D.DATALISTSPEC.nodes('tns:DataListSpec/tns:Output/tns:OutputFields/tns:OutputField') as datalistoutput(fields)