USP_SIMPLEDATALIST_CHILDEVENTSWITHMANAGEMENTOPTION

List of 'me and my children' events in an event hierarchy with the specified management option and appropriate site access

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@MANAGEMENTOPTIONNAME	nvarchar(30)	IN

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_CHILDEVENTSWITHMANAGEMENTOPTION 
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @MANAGEMENTOPTIONNAME nvarchar(30)
)
as
create table #CHILDEVENTSWITHSITEACCESS (ID uniqueidentifier, [NAME] nvarchar(100), [LEVEL] smallint);
insert into #CHILDEVENTSWITHSITEACCESS select ID, [NAME],[LEVEL] from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID);

select 
    [EVENTS].ID as VALUE,
    NAME as LABEL,
    case dbo.UFN_EVENTCOORDINATOR_PRIMARYCOUNT([EVENTS].ID) when 0 then 0 else 1 end as DESCRIPTION
from 
    #CHILDEVENTSWITHSITEACCESS [EVENTS]
left join
    dbo.EVENTMANAGEMENTOPTIONS EM on EM.EVENTID = [EVENTS].ID
where
    coalesce(CASE @MANAGEMENTOPTIONNAME
        when 'REGISTRANTSANDOPTIONS' then EM.HASREGISTRANTSANDOPTIONS
        when 'SPEAKERS' then EM.HASSPEAKERS
        when 'EXPENSES' then EM.HASEXPENSES
        when 'INVITATIONS' then EM.HASINVITATIONS
        when 'DOCUMENTATION' then EM.HASDOCUMENTATION
        when 'TASKSANDCOORDINATORS' then EM.HASTASKSANDCOORDINATORS
        when 'LODGINGOPTIONS' then EM.HASLODGINGOPTIONS
        when 'JOBOCCURRENCES' then EM.HASJOBOCCURRENCES
        when 'APPEALS' then EM.HASAPPEALS
        when 'CAMPAIGNS' then EM.HASCAMPAIGNS
        END, 1) = 1
order by 
    LEVEL asc;

drop table #CHILDEVENTSWITHSITEACCESS;