USP_DATALIST_EVENTCONSTITUENTREGISTRATIONS

List of all events related to a main event for which a constituent has been registered

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@EVENTID	uniqueidentifier	IN	[Not used]
@EXCLUDEREGISTRANTID	uniqueidentifier	IN	[Not used]

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTCONSTITUENTREGISTRATIONS
(
@CONSTITUENTID uniqueidentifier,
@EVENTID uniqueidentifier,
@EXCLUDEREGISTRANTID uniqueidentifier = null
)
as
    set nocount on;

    select R.EVENTID,
           NF.NAME HOSTNAME
    from 
        dbo.REGISTRANT R
    left join
        dbo.REGISTRANT Host on R.GUESTOFREGISTRANTID = Host.ID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(Host.CONSTITUENTID) NF
    where 
        @CONSTITUENTID <> 'C776DAB5-65B2-4258-ADAE-AE396D28E251' -- exclude "unknown guest" registrations

    and
        R.CONSTITUENTID = @CONSTITUENTID
    and
        R.EVENTID in (select ID from dbo.UFN_EVENT_GETMULTICOMPONENTSCHEDULES(@EVENTID))
    and
        R.ISCANCELLED <> 1
  and
    (@EXCLUDEREGISTRANTID is null or R.ID <> @EXCLUDEREGISTRANTID)