V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATECRITERIAEMAILINPUT

This view returns the input constituents and email addresses in which duplicate constituents will be identified in a differential search.

Fields

Field	Field Type	Null	Description
CONSTITID	uniqueidentifier		CONSTITID
NAME	nvarchar(254)	yes	NAME
EMAILADDRESS	UDT_EMAILADDRESS		EMAILADDRESS
ISGROUP	bit		ISGROUP

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:36:01 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATECRITERIAEMAILINPUT AS



                select  CONSTITUENT.ID as CONSTITID, 
                        CONSTITUENT.NAME + dbo.UFN_SUFFIXCODE_GETDESCRIPTION(CONSTITUENT.SUFFIXCODEID) as NAME, 
                        EMAILADDRESS.EMAILADDRESS,
                        CONSTITUENT.ISGROUP
                from    dbo.CONSTITUENT (nolock) inner join
                        dbo.EMAILADDRESS (nolock) on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID and EMAILADDRESS.ISPRIMARY = 1
                where    
                    CONSTITUENT.DATEADDED > (select convert (datetime, value)
                                     from fn_listextendedproperty('bb_FilterDate', default, default, default, default, default, default))