UFN_EVENTPREFERENCEGROUP_GETRELATEDEVENTPREFERENCEGROUPS

Returns all preference groups 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_EVENTPREFERENCEGROUP_GETRELATEDEVENTPREFERENCEGROUPS
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as
return
(
    select
        EVENTPREFERENCEGROUP.ID [EVENTPREFERENCEGROUPID],
        EVENTPREFERENCEGROUP.EVENTID [EVENTPREFERENCEGROUPEVENTID],
        EVENT.NAME [EVENTPREFERENCEGROUPEVENTNAME],
        EVENTPREFERENCEGROUP.NAME [EVENTPREFERENCEGROUPNAME]
    from
        dbo.EVENTPREFERENCEGROUP
        inner join dbo.EVENT on EVENTPREFERENCEGROUP.EVENTID = EVENT.ID
    where
        EVENTPREFERENCEGROUP.EVENTID in (select ID from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID))
)