V_QUERY_SMARTQUERYOUTPUT
Provides support for querying on the output for smart queries in the application catalog.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTQUERYID | uniqueidentifier | Smart Query ID | |
| NAME | nvarchar(max) | yes | Name |
| CAPTION | nvarchar(max) | yes | Caption |
| ISHIDDEN | int | yes | Is hidden |
| ISPRIMARYKEY | int | yes | Is primary key |
| DATATYPE | nvarchar(18) | yes | Data type |
| DEFAULTVALUE | nvarchar(max) | yes | Default value |
| ALLOWMONTHDAYONFUZZYDATE | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:54 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SMARTQUERYOUTPUT AS
with xmlnamespaces ('bb_appfx_smartquery' as tns, 'bb_appfx_commontypes' as common)
select
Q.ID as SMARTQUERYID,
smartqueryoutput.fields.value('@Name', 'nvarchar(max)') as NAME,
smartqueryoutput.fields.value('@Caption', 'nvarchar(max)') as CAPTION,
coalesce(smartqueryoutput.fields.value('@IsHidden', 'bit'), 0) as ISHIDDEN,
coalesce(smartqueryoutput.fields.value('@IsPrimaryKey', 'bit'), 0) as ISPRIMARYKEY,
coalesce(smartqueryoutput.fields.value('@DataType', 'nvarchar(18)'), 'String') as DATATYPE,
smartqueryoutput.fields.value('@DefaultValue', 'nvarchar(max)') as DEFAULTVALUE,
coalesce(smartqueryoutput.fields.value('@AllowMonthDayOnFuzzyDate', 'bit'), 0) as ALLOWMONTHDAYONFUZZYDATE
/*#EXTENSION*/
from dbo.SMARTQUERYCATALOG as Q
cross apply Q.SMARTQUERYSPEC.nodes('tns:SmartQuerySpec/tns:Output/tns:OutputFields/tns:OutputField') as smartqueryoutput(fields)