UFN_KPIINSTANCE_EXISTSFORCONTEXTRECORD

Evaluates whether a KPI instance exists for a given context record.

Return

Return Type
bit

Parameters

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

Definition

Copy



            create function dbo.UFN_KPIINSTANCE_EXISTSFORCONTEXTRECORD(@CONTEXTRECORDTYPE nvarchar(255), @CONTEXTRECORDID nvarchar(100))
            returns bit
            as
            begin

                declare @RETURNVALUE bit;

                set @RETURNVALUE = case 
                    when exists(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) then 1
                    else 0 end;

                return @RETURNVALUE;

            end;