USP_DATALIST_RE7INTEGRATIONCONSTITUENTMAPS_REVERSE

Returns the RE7 integration constituent mappings for a set of RE7 IDs.

Parameters

Parameter	Parameter Type	Mode	Description
@RE7RECORDIDS	xml	IN	RE7 Record IDs

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RE7INTEGRATIONCONSTITUENTMAPS_REVERSE(@RE7RECORDIDS xml)
                as
                    set nocount on;

                    select
                        RE7RECORDIDS.RE7RECORDID,
                        MAP.ID CONSTITUENTID,
                        CONSTITUENT.LOOKUPID LOOKUPID
                    from
                        dbo.UFN_RE7INTEGRATION_GETRE7RECORDIDS_FROMITEMLISTXML(@RE7RECORDIDS) RE7RECORDIDS
                    inner join
                        dbo.RE7INTEGRATIONCONSTITUENTMAP MAP on MAP.RE7RECORDID = RE7RECORDIDS.RE7RECORDID
                    inner join
                        dbo.CONSTITUENT on MAP.ID = CONSTITUENT.ID;