UFN_RE7INTEGRATION_GETRESEARCHGROUPMEMBERS_UNLINKED

This SQL function returns all members of a research group who are unlinked 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_UNLINKED(@RESEARCHGROUPID uniqueidentifier)
            returns table
            as
                return
                (
                    select
                        RESEARCHGROUPMEMBER.CONSTITUENTID as ID,
                        CONSTITUENT.NAME as NAME
                    from
                        dbo.RESEARCHGROUPMEMBER
                    inner join dbo.CONSTITUENT on
                        RESEARCHGROUPMEMBER.CONSTITUENTID = CONSTITUENT.ID
                    left outer join dbo.RE7INTEGRATIONCONSTITUENTMAP on
                        RE7INTEGRATIONCONSTITUENTMAP.ID = RESEARCHGROUPMEMBER.CONSTITUENTID
                    where
                        RESEARCHGROUPMEMBER.RESEARCHGROUPID = @RESEARCHGROUPID and
                        RE7INTEGRATIONCONSTITUENTMAP.RE7RECORDID is null
                );