USP_DATALIST_GROUPEDREGISTRANT

Displays the registrants for a given event grouped by that event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@ATTENDED	bit	IN	Attended

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_GROUPEDREGISTRANT
                (
                    @EVENTID uniqueidentifier,
                    @ATTENDED bit = null
                )
                as
                    set nocount on;

                    select 
                        REGISTRANT.ID,
                        dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID),
                        coalesce((select count(GUESTS.ID) from dbo.REGISTRANT as GUESTS where GUESTS.GUESTOFREGISTRANTID = REGISTRANT.ID),0),
                        REGISTRANT.ATTENDED,
                        dbo.UFN_REGISTRANT_GETHOSTNAME(REGISTRANT.ID, REGISTRANT.GUESTOFREGISTRANTID),
                        case when REGISTRANT.CONSTITUENTID is not null then 0 else 1 end as ISUNKNOWNGUEST,
                        dbo.UFN_EVENTREGISTRANT_GETBALANCE(REGISTRANT.ID) [BALANCE],
                        EVENT.NAME EVENT,
                        EVENT.BASECURRENCYID
                    from 
                        dbo.REGISTRANT
                        inner join dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
                    where 
                        (REGISTRANT.EVENTID = @EVENTID or REGISTRANT.EVENTID in (select EVENT.ID from dbo.EVENT where EVENT.MAINEVENTID = @EVENTID)) 
                        and (
                            (@ATTENDED is null) 
                            or (REGISTRANT.ATTENDED = @ATTENDED)
                        )
                    order by
                        REGISTRANT.DATEADDED;