USP_DATALIST_EVENTCOORDINATORS

Displays the coordinators for the given event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@INCLUDESUBEVENTS	bit	IN	Include sub-events

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTCOORDINATORS
(
  @EVENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @INCLUDESUBEVENTS bit = 0
)
as
  set nocount on;

  select 
    EVENTCOORDINATOR.ID,
    NF.NAME as COORDINATOR,
    EVENTS.NAME as [EVENTNAME],
    EVENTCOORDINATOR.CONSTITUENTID,
    EVENTCOORDINATOR.ISPRIMARY
  from 
    dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID) EVENTS
  inner join
    dbo.EVENTCOORDINATOR on EVENTCOORDINATOR.EVENTID = EVENTS.ID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTCOORDINATOR.CONSTITUENTID) NF
  where
    EVENTS.ID = @EVENTID
    or @INCLUDESUBEVENTS = 1
  order by
    EVENTS.LEVEL asc, EVENTS.NAME asc, COORDINATOR;