USP_KPIINSTANCE_GETLISTBYCONTEXTRECORD

Returns a list of KPI instances which correspond to a given context record.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTRECORDTYPE	nvarchar(255)	IN
@CONTEXTRECORDID	nvarchar(100)	IN

Definition

Copy



            create procedure dbo.USP_KPIINSTANCE_GETLISTBYCONTEXTRECORD(@CONTEXTRECORDTYPE nvarchar(255), @CONTEXTRECORDID nvarchar(100))
            as

                set nocount on;

                select KPIINSTANCE.ID from dbo.KPIINSTANCE 
                join dbo.KPICATALOG on KPIINSTANCE.KPICATALOGID = KPICATALOG.ID
                join dbo.RECORDTYPE on KPICATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
                where RECORDTYPE.NAME = @CONTEXTRECORDTYPE
                    and KPIINSTANCE.CONTEXTRECORDID = @CONTEXTRECORDID;