USP_DATALIST_INVITATION

This datalist displays saved invitation process parameter sets.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_INVITATION

                @CURRENTAPPUSERID uniqueidentifier = NULL

                as
                    set nocount on;

                    select
                        I.ID,
                        I.NAME,
                        E.NAME AS EVENT,
                        I.DESCRIPTION,
                        E.ID AS EVENTID
                    from
                        dbo.INVITATION AS I
                        left join dbo.EVENT AS E ON I.EVENTID=E.ID

                        WHERE  (@CURRENTAPPUSERID IS NULL OR dbo.UFN_EVENT_USERHASSITEACCESS(@CURRENTAPPUSERID, E.ID) = 1)
                    order by
                        I.NAME;