UFN_RE7INTEGRATION_GETSELECTEDTORE7FIELDS

This SQL function returns all The Raiser's Edge integration fields that have been selected.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DIRECTIONCODE	tinyint	IN

Definition

Copy



            create function dbo.UFN_RE7INTEGRATION_GETSELECTEDTORE7FIELDS(@DIRECTIONCODE tinyint)
            returns table
            as
                return
                (
                    select
                        RE7INTEGRATIONSELECTEDFIELD.ID
                    from
                        dbo.RE7INTEGRATIONSELECTEDFIELD
                    left join
                        dbo.RE7INTEGRATIONAVAILABLEFIELD
                    on
                        RE7INTEGRATIONAVAILABLEFIELD.ID = RE7INTEGRATIONSELECTEDFIELD.ID
                    where
                        RE7INTEGRATIONAVAILABLEFIELD.DIRECTIONCODE = @DIRECTIONCODE
                );