USP_DATAFORMTEMPLATE_EDITLOAD_CONFIDENCESETTINGS

The load procedure used by the edit dataform template "WealthPoint Confidence Settings Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@RATINGSGROUPS	xml	INOUT	Select a source
@MANUALCONFIDENCE	int	INOUT	Set manually entered records to
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONFIDENCESETTINGS(
                    @DATALOADED bit = 0 output,
                    @RATINGSGROUPS xml = null output,
                    @MANUALCONFIDENCE int = null output,
                    @TSLONG bigint = 0 output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;
                    set @TSLONG = 0;

                    set @RATINGSGROUPS=
                        (select
                            ID as WEALTHSOURCEID,
                            (select
                                CR.MATCHCODEID,
                                CR.CONFIDENCE
                            from
                                dbo.CONFIDENCERATING CR
                            left join dbo.MATCHCODE MC on
                                CR.MATCHCODEID = MC.ID
                            where
                                CR.WEALTHSOURCEID = WS.ID and 
                CR.ALLOWUSEREDIT = 1 and
                                exists(
                                    select 1 from 
                                        dbo.CONFIDENCERATINGINSTALLEDPRODUCT CRIP
                                    where 
                                        CRIP.CONFIDENCERATINGID = CR.ID and exists(select 1 from dbo.INSTALLEDPRODUCTLIST where ID = CRIP.INSTALLEDPRODUCTID))
                            order by 
                                CR.CONFIDENCE, SUBSTRING(MC.MATCHCODE,2,2), SUBSTRING(MC.MATCHCODE,1,1)

                            for xml raw('ITEM'),type,elements,root('RATINGS'),BINARY BASE64)
                        from
                            dbo.WEALTHSOURCE WS
                        where
                            ISBUILTIN = 1
                        order by
                            WS.SEQUENCE
                        for xml raw('ITEM'),type,elements,root('RATINGSGROUPS'),BINARY BASE64)    


                    if @RATINGSGROUPS is not null        
                        select
                            @TSLONG = max(TSLONG)
                        from
                            dbo.CONFIDENCERATING                        
                    else
                        set @TSLONG = 0;


                    select top(1) 
                        @MANUALCONFIDENCE = WPC.MANUALCONFIDENCE
                    from
                        dbo.WEALTHPOINTCONFIGURATION WPC

                    set @DATALOADED = 1;

                    return 0;