UFN_DATAFORMINSTANCE_GETSYSTEMROLEKPIINSTANCEASSIGNMENTSLIST
Returns a table of IDs for all system roles that have been assigned the given KPI instance
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @KPIINSTANCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_DATAFORMINSTANCE_GETSYSTEMROLEKPIINSTANCEASSIGNMENTSLIST(@KPIINSTANCEID uniqueidentifier)
/*
Returns a table of IDs for all system roles that have been assigned the given KPI instance
*/
returns table
as
return
(
select
SRK.ID, SR.NAME, SRK.SYSTEMROLEID, cast(1 as bit) as GRANTORDENY
from
dbo.SYSTEMROLE as SR left outer join dbo.SYSTEMROLEKPIINSTANCE as SRK on SR.ID = SRK.SYSTEMROLEID
where
SRK.KPIINSTANCEID = @KPIINSTANCEID
)