USP_DATALIST_UNPAIDPATRONEVENTREGISTRATION

Unpaid patron event registration list.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Patron
@EVENTID	uniqueidentifier	IN	Event
@FILTERZEROBALANCE	bit	IN	Filter zero balance registrations
@MAXRESULTS	int	IN	Maximum results

Definition

Copy



CREATE procedure dbo.USP_DATALIST_UNPAIDPATRONEVENTREGISTRATION
(
    @CONSTITUENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier = null,
    @FILTERZEROBALANCE bit = 1,
    @MAXRESULTS integer = 0
)
as
    set nocount on;

    -- This seems hacky, but since UFN_GETUNPAIDPATRONEVENTREGISTRATIONS is not inline,

    -- doing a select top (@MAXROWS) is extremely slow

    set rowcount @MAXRESULTS;

    select
        [REGISTRANTID],
        [REGISTRANTNAME],
        [EVENTNAME],
        [EVENTDATE],
        [BALANCE],
        [EVENTALLOWSDESIGNATIONSONFEES]
    from dbo.UFN_GETUNPAIDPATRONEVENTREGISTRATIONS(@CONSTITUENTID, null, @EVENTID, @FILTERZEROBALANCE);

    return 0;