UFN_RE7INTEGRATION_GETRESEARCHGROUPMEMBERS_LINKED

This SQL function returns all members of a research group who are linked to a RE7 record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RESEARCHGROUPID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_RE7INTEGRATION_GETRESEARCHGROUPMEMBERS_LINKED(@RESEARCHGROUPID uniqueidentifier)
            returns table
            as
                return
                (
                    select
                        RESEARCHGROUPMEMBER.CONSTITUENTID as ID,
                        RE7INTEGRATIONCONSTITUENTMAP.RE7RECORDID as RE7RECORDID
                    from
                        dbo.RESEARCHGROUPMEMBER
                    inner join dbo.CONSTITUENT on
                        RESEARCHGROUPMEMBER.CONSTITUENTID = CONSTITUENT.ID
                    inner join dbo.RE7INTEGRATIONCONSTITUENTMAP    on
                        RE7INTEGRATIONCONSTITUENTMAP.ID = RESEARCHGROUPMEMBER.CONSTITUENTID

                    where
                        RESEARCHGROUPMEMBER.RESEARCHGROUPID = @RESEARCHGROUPID
                );