USP_DATALIST_APPUSERKPIS

Returns a list of KPI permissions granted to the given application user

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_APPUSERKPIS (@APPUSERID uniqueidentifier)
as
    set nocount on;

    select distinct KPIINSTANCE.NAME,
        KPIINSTANCE.DESCRIPTION,
        KPICATALOG.NAME KPINAME
    from dbo.SYSTEMROLEKPIINSTANCE
    inner join dbo.SYSTEMROLEAPPUSER as SRAU on SYSTEMROLEKPIINSTANCE.SYSTEMROLEID = SRAU.SYSTEMROLEID
    inner join dbo.KPIINSTANCE on SYSTEMROLEKPIINSTANCE.KPIINSTANCEID = KPIINSTANCE.ID
    inner join dbo.KPICATALOG on KPIINSTANCE.KPICATALOGID = KPICATALOG.ID
    where SRAU.APPUSERID = @APPUSERID;

    return 0;