UFN_EVENT_GETAPPEALSWITHRECORDSECURITY

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@DATAFORMINSTANCEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@USERISADMIN	bit	IN

Definition

Copy



create function dbo.UFN_EVENT_GETAPPEALSWITHRECORDSECURITY
(
    @EVENTID uniqueidentifier,
    @DATAFORMINSTANCEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @USERISADMIN bit
) returns table as
    return (
        select
            EVENTAPPEAL.ID,
            EVENTAPPEAL.APPEALID,
            case @USERISADMIN when 1 then 1 when 0 then dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORSITE(@CURRENTAPPUSERID, @DATAFORMINSTANCEID, APPEAL.SITEID) end USERHASACCESS
        from
            dbo.EVENTAPPEAL
        inner join
            dbo.APPEAL on APPEAL.ID = EVENTAPPEAL.APPEALID
        where
            EVENTID = @EVENTID
        );