USP_DATALIST_EVENT_DONOR

Returns all Event Donor records.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	EventID
@REGISTRANTID	uniqueidentifier	IN	RegistrantID
@CONSTITUENTID	uniqueidentifier	IN	ConstituentID
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN	TeamFundraisingTeamID

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENT_DONOR
    (@EVENTID uniqueidentifier = null,
     @REGISTRANTID uniqueidentifier = null,
     @CONSTITUENTID uniqueidentifier = null,
     @TEAMFUNDRAISINGTEAMID uniqueidentifier = null
    ) with execute as caller
as
    set nocount on;

    select 
        EVENTDONOR.[ID],
        EVENTDONOR.[EVENTID],
        EVENTDONOR.[CONSTITUENTID],
        EVENTDONOR.[REGISTRANTID],
        EVENTDONOR.[TEAMFUNDRAISINGTEAMID],
        EVENTDONOR.[DONATIONAMOUNT]
    from 
        dbo.EVENTDONOR
    where
        EVENTID = ISNULL(@EVENTID,EVENTID) AND CONSTITUENTID = ISNULL(@CONSTITUENTID,CONSTITUENTID)
        AND REGISTRANTID = ISNULL(@REGISTRANTID,REGISTRANTID) AND TEAMFUNDRAISINGTEAMID = ISNULL(@TEAMFUNDRAISINGTEAMID,TEAMFUNDRAISINGTEAMID)