USP_DATALIST_REGISTRANTGUESTS

Displays the guests for the given registrant.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_REGISTRANTGUESTS
                (
                    @REGISTRANTID uniqueidentifier,
                    @ATTENDED bit = null
                )
                as
                    set nocount on;

                    select 
                        REGISTRANT.ID,
                        dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID),
                        REGISTRANT.ATTENDED,
                        case when REGISTRANT.CONSTITUENTID is not null then 0 else 1 end as ISUNKNOWNGUEST
                    from 
                        dbo.REGISTRANT                         
                    where 
                        GUESTOFREGISTRANTID = @REGISTRANTID and 
                        (
                            (@ATTENDED is null) 
                                or 
                            (ATTENDED = @ATTENDED)
                        )
                    order by
                        REGISTRANT.DATEADDED;