USP_DATALIST_DESIGNATIONLEVELGOALS

Displays a list of goals for a fundraising purpose.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONLEVELGOALS (@ID uniqueidentifier)
                as begin

                    set nocount on;

                    WITH XMLNAMESPACES (
                      'bb_appfx_dataforms' AS DFI)

                    select 
                        DESIGNATIONLEVELGOAL.ID,
                        DESIGNATIONLEVELGOAL.NAME,
                        DESIGNATIONLEVELGOAL.GOAL,
                        DESIGNATIONLEVELGOAL.STARTDATE,
                        DESIGNATIONLEVELGOAL.ENDDATE,
                        (select top 1 KPIINSTANCE.ID
                            from dbo.KPIINSTANCE 
                            where KPIINSTANCE.CONTEXTRECORDID = cast(DESIGNATIONLEVELGOAL.DESIGNATIONLEVELID as nvarchar(100))
                            and KPIINSTANCE.PARAMETERSXML.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="DESIGNATIONLEVELGOALID"]/DFI:Value)[1]','varchar(36)') = cast(DESIGNATIONLEVELGOAL.ID as varchar(36))) as KPIINSTANCEID,
                        DESIGNATIONLEVELGOAL.DESIGNATIONLEVELID as KPICONTEXTID,
                        DESIGNATIONLEVELGOAL.BASECURRENCYID
                    from
                        dbo.DESIGNATIONLEVELGOAL
                    where
                        DESIGNATIONLEVELGOAL.DESIGNATIONLEVELID = @ID
                    order by
                        DESIGNATIONLEVELGOAL.STARTDATE;

                end