USP_DATALIST_CONSTITUENTREGISTRANTS

Lists the registrant records for the given constituent.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_CONSTITUENTREGISTRANTS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @EVENTID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        REGISTRANT.ID,
                        [HOST].ID [HOSTREGISTRANTID],
                        [HOST].CONSTITUENTID [HOSTCONSTITUENTID],
                        dbo.UFN_CONSTITUENT_BUILDNAME([HOST].CONSTITUENTID) [HOSTNAME],
                        EVENT.ID [EVENTID],
                        EVENT.NAME [EVENTNAME]
                    from
                        dbo.REGISTRANT
                        left join dbo.EVENT on REGISTRANT.EVENTID = EVENT.ID
                        left join dbo.REGISTRANT [HOST] on REGISTRANT.GUESTOFREGISTRANTID = [HOST].ID
                    where
                        REGISTRANT.CONSTITUENTID = @CONSTITUENTID
                        and
                        (
                            @EVENTID is null
                            or
                            EVENT.ID = @EVENTID
                            or
                            EVENT.MAINEVENTID = @EVENTID
                        )
                    order by
                        EVENT.NAME;