USP_DATALIST_REGISTRANTVIEW

List registrations for a given constituent.
Parameters

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

Copy


                    create procedure dbo.USP_DATALIST_REGISTRANTVIEW(
                        @ID uniqueidentifier
                    )
                    as
                    set nocount on;


                    select
                        REGISTRANT.ID,
                        REGISTRANT.EVENTID,
                        dbo.UFN_EVENT_GETNAME(REGISTRANT.EVENTID),
                        (select STARTDATE from dbo.EVENT where ID = REGISTRANT.EVENTID) [STARTDATE],
                        dbo.UFN_EVENTPRICE_GETNAME(REGISTRANTREGISTRATION.EVENTPRICEID),
                        REGISTRANTREGISTRATION.QUANTITY,
                        REGISTRANTREGISTRATION.AMOUNT,
                        REGISTRANTREGISTRATION.RECEIPTAMOUNT
                        --REGISTRANTREGISTRATION.AMOUNT - (dbo.UFN_EVENTREGISTRANT_GETBALANCE(REGISTRANTREGISTRATION.ID))

                        --(select NAME from dbo.CONSTITUENT inner join dbo.REGISTRANT R on CONSTITUENT.ID = R.CONSTITUENTID where R.ID = REGISTRANT.GUESTOFREGISTRANTID)

                        --case when exists(select REGISTRATIONPACKAGEID from dbo.REGISTRANTREGISTRATION where REGISRTANTID = REGISTRANT.ID ) then 1 else 0 end

                    from
                        dbo.REGISTRANT
                    inner join
                        dbo.CONSTITUENT
                    on
                        REGISTRANT.CONSTITUENTID = CONSTITUENT.ID
                    left join
                        dbo.REGISTRANTREGISTRATION
                    on
                        REGISTRANT.ID = REGISTRANTREGISTRATION.REGISTRANTID
                    where
                        CONSTITUENT.ID = @ID
                    order by
                        [STARTDATE] desc;