V_QUERY_RECORDOPERATIONEXPECTEDCONSTRAINTEXCEPTIONS
Provides support for querying on the expected constraint exceptions for record operations from the application catalog.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDOPERATIONID | uniqueidentifier | Record Operation ID | |
| NAME | nvarchar(max) | yes | Name |
| FIELD | nvarchar(max) | yes | Field |
| TYPE | nvarchar(max) | yes | Type |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/2/2010 7:06:40 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECORDOPERATIONEXPECTEDCONSTRAINTEXCEPTIONS AS
with xmlnamespaces ('bb_appfx_recordoperation' as tns, 'bb_appfx_commontypes' as common)
select
R.ID as RECORDOPERATIONID,
exception.constraints.value('@Name', 'nvarchar(max)') as NAME,
exception.constraints.value('@Field', 'nvarchar(max)') as FIELD,
exception.constraints.value('@Type', 'nvarchar(max)') as TYPE
/*#EXTENSION*/
from dbo.RECORDOPERATIONCATALOG as R
cross apply R.RECORDOPERATIONSPECXML.nodes('tns:RecordOperationSpec/tns:SPRecord/tns:ExpectedOperationDBExceptions/common:Constraints/common:Constraint') as exception(constraints)