UFN_EVENTPREFERENCEGROUP_GETMULTICOMPONENTEVENTPREFERENCEGROUPS

Returns all preference groups for a given event and its supporting events.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTPREFERENCEGROUP_GETMULTICOMPONENTEVENTPREFERENCEGROUPS
            (
                @EVENTID 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 = @EVENTID
                    or EVENT.MAINEVENTID = @EVENTID
            )