UFN_EVENT_GETRELATEDEVENTAPPEALS

Returns all linked appeals for a given event and its related events.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_EVENT_GETRELATEDEVENTAPPEALS
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as
return
(
    select
        EVENT.ID [EVENTID],
        EVENT.APPEALID
    from
        dbo.EVENT
    where
        EVENT.ID in (select ID from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID))
)