UFN_CHILDEVENTSWITHSITEACCESS

Set of child events in event hierarchy that satisfy site security. Includes event whose ID is passed as parameter.

Return

Return Type
table

Parameters

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

Definition

Copy



CREATE function dbo.UFN_CHILDEVENTSWITHSITEACCESS
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as return
    select
        EVENT.ID, NAME, 1 As LEVEL
    from 
        dbo.EVENT
    where
        ID = @EVENTID
    and
        dbo.UFN_EVENT_USERHASSITEACCESS(@CURRENTAPPUSERID, EVENT.ID) = 1

    union all

    select
        EVENT.ID, NAME, NODE.HIERARCHYPATH.GetLevel() As LEVEL
    from
        dbo.EVENTHIERARCHY ROOT
    inner join
        dbo.EVENTHIERARCHY NODE on NODE.HIERARCHYPATH.IsDescendantOf(ROOT.HIERARCHYPATH) = 1
    inner join
        dbo.EVENT on NODE.ID = EVENT.ID
    where
        ROOT.ID = @EVENTID
    and
        NODE.ID <> @EVENTID
    and
        dbo.UFN_EVENT_USERHASSITEACCESS(@CURRENTAPPUSERID, NODE.ID) = 1