UFN_MAILPREFERENCE_GETGROUPCONTACTS

Returns the group members that are recipients for the given mail preference.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MAILPREFERENCEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_MAILPREFERENCE_GETGROUPCONTACTS
            (
                @MAILPREFERENCEID uniqueidentifier
            ) returns table
            as
                return(
                    select
                        ID,
                        CONSTITUENTID,
                        USEPRIMARYCONTACT,
                        ADDRESSID,
                        EMAILADDRESSID,
                        USEPRIMARYADDRESS,
                        USEPRIMARYEMAIL
                    from
                        dbo.MAILPREFERENCEGROUPCONTACT
                    where
                        MAILPREFERENCEID = @MAILPREFERENCEID
                )