UFN_MAILPREFERENCEGROUPCONTACT_ISCURRENTMEMBER

Verifies that the constituent listed as a contact for a group is a current member of that group.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@MAILPREFERENCEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_MAILPREFERENCEGROUPCONTACT_ISCURRENTMEMBER (
                @MAILPREFERENCEID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            ) 
            returns bit as 
            begin
                declare @GROUPMEMBERID uniqueidentifier;
                select
                    @GROUPMEMBERID = GROUPMEMBER.ID
                from
                    dbo.MAILPREFERENCE
                inner join
                    dbo.GROUPMEMBER on GROUPMEMBER.GROUPID = MAILPREFERENCE.CONSTITUENTID and GROUPMEMBER.MEMBERID = @CONSTITUENTID
                where
                    MAILPREFERENCE.ID = @MAILPREFERENCEID
                return dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(@GROUPMEMBERID);
            end