USP_DATALIST_DESIGNATIONGOALS

Displays a list of goals for a designation.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONGOALS (@DESIGNATIONID uniqueidentifier)
                as begin

                    set nocount on;

                    WITH XMLNAMESPACES (
                      'bb_appfx_dataforms' AS DFI)

                    select 
                        GOALS.ID,
                        @DESIGNATIONID as DESIGNATIONID,
                        GOALS.NAME,
                        GOALS.GOAL,
                        GOALS.STARTDATE,
                        GOALS.ENDDATE,
                        (select top 1 KPIINSTANCE.ID 
                            from dbo.KPIINSTANCE
                            where KPIINSTANCE.CONTEXTRECORDID = cast(@DESIGNATIONID as nvarchar(36))
                            and KPIINSTANCE.PARAMETERSXML.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="DESIGNATIONGOALID"]/DFI:Value)[1]','nvarchar(36)') = cast(GOALS.ID as nvarchar(36))) as KPIINSTANCEID,
                        @DESIGNATIONID as KPICONTEXTID,
                        GOALS.DESIGNATIONLEVELGOALID DESIGNATIONLEVELGOALID,
                        GOALS.BASECURRENCYID
                    from
                        dbo.UFN_DESIGNATION_GETGOALS(@DESIGNATIONID) as GOALS

                end