V_QUERY_DATAFORMINSTANCEEXPECTEDCUSTOMEXCEPTIONS
Provides support for querying on the expected custom exceptions for data form instances in the application catalog.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATAFORMINSTANCEID | uniqueidentifier | Data form instance ID | |
| FIELD | nvarchar(max) | yes | Field |
| SEARCHTEXT | nvarchar(max) | yes | Search text |
| ERRORCODE | int | yes | Error code |
| CUSTOMERRORMSG | nvarchar(max) | yes | Custom error message |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/2/2010 7:06:19 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DATAFORMINSTANCEEXPECTEDCUSTOMEXCEPTIONS AS
with xmlnamespaces ('bb_appfx_commontypes' as common)
select
INSTANCE.ID as DATAFORMINSTANCEID,
exception.customs.value('@Field', 'nvarchar(max)') as FIELD,
exception.customs.value('@SearchText', 'nvarchar(max)') as SEARCHTEXT,
coalesce(exception.customs.value('@ErrorCode', 'integer'), 0) as ERRORCODE,
exception.customs.value('common:CustomErrorMsg[1]', 'nvarchar(max)') as CUSTOMERRORMSG
/*#EXTENSION*/
from dbo.DATAFORMINSTANCECATALOG as INSTANCE
inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
cross apply EXCEPTIONSXML.nodes('ExpectedDBExceptions/common:CustomExceptions/common:Exception') as exception(customs)