V_QUERY_RECORDOPERATIONEXPECTEDCUSTOMEXCEPTIONS
Provides support for querying on the expected custom exceptions for record operations from the application catalog.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDOPERATIONID | uniqueidentifier | Record Operation 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:41 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECORDOPERATIONEXPECTEDCUSTOMEXCEPTIONS AS
with xmlnamespaces ('bb_appfx_recordoperation' as tns, 'bb_appfx_commontypes' as common)
select
R.ID as RECORDOPERATIONID,
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.RECORDOPERATIONCATALOG as R
cross apply R.RECORDOPERATIONSPECXML.nodes('tns:RecordOperationSpec/tns:SPRecord/tns:ExpectedOperationDBExceptions/common:CustomExceptions/common:Exception') as exception(customs)