USP_DATALIST_PREREGISTEREDPROGRAMEVENTREGISTRANTMOBILE

Returns a list of registrants for a preregistered program event for use on mobile.
Parameters

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

Copy


                CREATE procedure dbo.USP_DATALIST_PREREGISTEREDPROGRAMEVENTREGISTRANTMOBILE
                (
                    @CONTEXTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        REGISTRANT.ID as ID,
                        case 
                            when REGISTRANT.CONSTITUENTID is not null then
                                dbo.UFN_CONSTITUENT_BUILDNAME(REGISTRANT.CONSTITUENTID)
                            when REGISTRANT.GUESTOFREGISTRANTID is not null then
                                dbo.UFN_REGISTRANT_GETHOSTNAME(REGISTRANT.ID, REGISTRANT.GUESTOFREGISTRANTID) 
                            else ''
                        end as REGISTRANTNAME,
                        coalesce((
                            select dbo.UDA_BUILDLIST(EVENTPREFERENCE.NAME) 
                            from dbo.EVENTPREFERENCE
                            inner join dbo.REGISTRANTPREFERENCE on
                                EVENTPREFERENCE.ID = REGISTRANTPREFERENCE.EVENTPREFERENCEID
                            where
                                REGISTRANTPREFERENCE.REGISTRANTID = REGISTRANT.ID
                        ),'') as PREFERENCES,
                        case
                            when REGISTRANT.CONSTITUENTID is null then 1
                            else 0
                        end as ISUNNAMEDGUEST,
                        REGISTRANT.ATTENDED as ATTENDED,
                        REGISTRANT.ISCANCELLED as CANCELLED
                    from dbo.REGISTRANT 
                    left join dbo.SALESORDERITEMTICKETREGISTRANT on REGISTRANT.ID = SALESORDERITEMTICKETREGISTRANT.REGISTRANTID
                    left join dbo.SALESORDERITEM on SALESORDERITEMTICKETREGISTRANT.SALESORDERITEMTICKETID = SALESORDERITEM.ID
                    where 
                        REGISTRANT.EVENTID = @CONTEXTID
                        and REGISTRANT.WILLNOTATTEND = 0
                    order by REGISTRANTNAME, ISUNNAMEDGUEST