UFN_KPICATALOG_GETCURRENCYFIELDID

Gets the field ID of the parameter to use for goal or KPI values currency formatting for a given KPI.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@KPICATALOGID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_KPICATALOG_GETCURRENCYFIELDID(@KPICATALOGID uniqueidentifier)
returns nvarchar(max)
as
begin

    declare @RETURNVALUE nvarchar(max);

    select
        @RETURNVALUE = KPICATALOG.SPECXML.value('declare namespace kpi="bb_appfx_kpi"; (/kpi:KpiSpec/kpi:KpiFormDefinition)[1]/@CurrencyFieldID', 'nvarchar(max)')
    from
        dbo.KPICATALOG
    where
        ID = @KPICATALOGID;

    return @RETURNVALUE;

end;