UFN_BATCHWORKFLOWSTATE_GETSYSTEMROLEPERMISSIONS

This SQL function returns all of the system role permissions for a given batch workflow state.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHWORKFLOWSTATEID	uniqueidentifier	IN

Definition

Copy



            create function UFN_BATCHWORKFLOWSTATE_GETSYSTEMROLEPERMISSIONS
            (
                @BATCHWORKFLOWSTATEID as uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    SYSTEMROLEPERM_BATCHWORKFLOWSTATE.ID,
                    SYSTEMROLE.ID as SYSTEMROLEID,
                    SYSTEMROLE.NAME,
                    coalesce(SYSTEMROLEPERM_BATCHWORKFLOWSTATE.GRANTORDENY, 2) as GRANTORDENY

                from
                    dbo.SYSTEMROLE
                    left outer join dbo.SYSTEMROLEPERM_BATCHWORKFLOWSTATE
                        on SYSTEMROLE.ID = SYSTEMROLEPERM_BATCHWORKFLOWSTATE.SYSTEMROLEID
                        and SYSTEMROLEPERM_BATCHWORKFLOWSTATE.BATCHWORKFLOWSTATEID = @BATCHWORKFLOWSTATEID
            )