UFN_CONSTITUENT_ISCOMMUNITYMEMBER

This functions returns whether a constituent is a member of the Blackbaud Internet Solutions site.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_CONSTITUENT_ISCOMMUNITYMEMBER(@CONSTITUENTID uniqueidentifier)
        returns bit
        with execute as caller
        as
        begin

            declare @ISBBNC tinyint

            if @CONSTITUENTID is not null
                begin
                    select @ISBBNC = NETCOMMUNITYMEMBER from dbo.CONSTITUENT where ID = @CONSTITUENTID
                    if @ISBBNC = 0 return 0
                end
            return 1
        end