USP_DATALIST_MATCHINGGIFTCONDITIONS

This datalist returns all matching gift conditions for an organization.

Parameters

Parameter	Parameter Type	Mode	Description
@ORGANIZATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_MATCHINGGIFTCONDITIONS (@ORGANIZATIONID uniqueidentifier)
            as
                set nocount on;

                select
                    MATCHINGGIFTCONDITION.ID,
                    MATCHINGGIFTCONDITIONTYPECODE.DESCRIPTION,
                    case
                        when exists(select 1 from REVENUEMATCHINGGIFT where REVENUEMATCHINGGIFT.MATCHINGGIFTCONDITIONID = MATCHINGGIFTCONDITION.ID)
                            then 1
                        else 0
                    end INUSE
                from dbo.MATCHINGGIFTCONDITION
                    inner join dbo.CONSTITUENT on MATCHINGGIFTCONDITION.ORGANIZATIONID = CONSTITUENT.ID
                    inner join dbo.MATCHINGGIFTCONDITIONTYPECODE on MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID = MATCHINGGIFTCONDITIONTYPECODE.ID
                where MATCHINGGIFTCONDITION.ORGANIZATIONID = @ORGANIZATIONID 
                    and CONSTITUENT.ISORGANIZATION = 1
                order by MATCHINGGIFTCONDITION.SEQUENCE;