USP_DATALIST_CONSTITUENTGROUPEVENT

This returns a list of all events a group is a coordinator for.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENTGROUPEVENT
                (
                    @CONTEXTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as
                    set nocount on;

                    select distinct EVENTCOORDINATOR.EVENTID,
                                    EVENTCOORDINATOR.ID,
                                    EVENT.NAME EVENTNAME
                    from dbo.EVENTCOORDINATOR
                        inner join dbo.EVENT on EVENTCOORDINATOR.EVENTID = EVENT.ID
                        left join dbo.EVENTSITE on EVENTCOORDINATOR.EVENTID = EVENTSITE.EVENTID
                    where
                        (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[EVENTSITE].[SITEID] or (SITEID is null and [EVENTSITE].[SITEID] is null))) and
                        CONSTITUENTID = @CONTEXTID
                    order by EVENTNAME;