USP_SIMPLEDATALIST_EVENTSITES

List of all sites in the system that a given user could interact with (based on Role assignments) and any sites assigned to the event that the user does not otherwise have access.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@EVENTID	uniqueidentifier	IN	EVENTID

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_EVENTSITES
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @EVENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select                     
                        SFU.[SITEID] as VALUE, 
                        SITE.[NAME] as LABEL                         
                    from                     
                        dbo.SITE 
                        inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) AS SFU ON SFU.SITEID = SITE.ID
                    union
                    select
                        EVENTSITE.SITEID as VALUE,
                        SITE.NAME as LABEL
                    from
                        dbo.EVENTSITE
                        inner join dbo.SITE on SITE.ID = EVENTSITE.SITEID
                    where
                        EVENTSITE.EVENTID = @EVENTID
                    order by
                        LABEL