UFN_CONSTITUENT_GETDUPLICATECANDIDATES

Returns a list of constituents in the database that are similar to the criterion.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@KEYNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@POSTCODE	nvarchar(12)	IN
@ADDRESSBLOCK	nvarchar(150)	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_GETDUPLICATECANDIDATES(
                @KEYNAME nvarchar(100),
                @FIRSTNAME nvarchar(50) = '',
                @POSTCODE nvarchar(12),
                @ADDRESSBLOCK nvarchar(150) = ''
            ) 
            returns @DUPLICATECANDIDATES table(
                CONSTITUENTID uniqueidentifier,
                ADDRESSID uniqueidentifier,
                MATCHPERCENTAGE numeric(5, 2)
            ) as
            begin

                if @KEYNAME is null or len(@KEYNAME) = 0 or @POSTCODE is null or len(@POSTCODE) = 0
                    return

                -- todo generify

                insert into @DUPLICATECANDIDATES (
                    CONSTITUENTID,
                    ADDRESSID,
                    MATCHPERCENTAGE
                )
                select 
                    CONSTITUENTID,
                    ADDRESSID,
                    MATCHPERCENTAGE
                from
                    dbo.UFN_CONSTITUENT_GETTHRESHOLDFUZZYDUPLICATES (
                        @KEYNAME,
                        @FIRSTNAME,
                        @POSTCODE,
                        @ADDRESSBLOCK,
                        null
                    )

                return;
            end