UFN_CONSTITUENT_GETGROUPS

This function returns all the groups that currently contain this constituent.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_CONSTITUENT_GETGROUPS(@MEMBERID uniqueidentifier)
        returns table
        as return
            select CG.ID,
                CG.NAME
            from dbo.GROUPMEMBER as GM
            join dbo.CONSTITUENT as CG ON GM.GROUPID = CG.ID
            where GM.MEMBERID = @MEMBERID
            and dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GM.ID) = 1