V_QUERY_DATAFORMINSTANCEEXPECTEDCONSTRAINTEXCEPTIONS
Provides support for querying on the expected constraint exceptions for data form instances in the application catalog.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATAFORMINSTANCEID | uniqueidentifier | Data form instance 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:18 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DATAFORMINSTANCEEXPECTEDCONSTRAINTEXCEPTIONS AS
with xmlnamespaces ('bb_appfx_commontypes' as common)
select
INSTANCE.ID as DATAFORMINSTANCEID,
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.DATAFORMINSTANCECATALOG as INSTANCE
inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
cross apply EXCEPTIONSXML.nodes('ExpectedDBExceptions/common:Constraints/common:Constraint') as exception(constraints)