UFN_CONSTITUENT_HASCOMMUNITYDATA

This functions returns true if integration data from Blackbaud Internet Solutions is linked to the given constituent.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_HASCOMMUNITYDATA(@CONSTITUENTID uniqueidentifier)
            returns bit
            with execute as caller
            as
            begin
                if exists
                (
                    select
                        ID
                    from
                        dbo.NETCOMMUNITYEMAILJOBRECIPIENT
                    where
                        CONSTITUENTID = @CONSTITUENTID
                )
                    return 1;

                return 0;
            end