USP_DATALIST_WEALTHINFORMATIONDASHBOARDRESEARCHSUMMARY

This datalist returns WealthPoint research summary information that is used by the wealth information dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ISVISIBLE	bit	IN	Visible

Definition

Copy



create procedure dbo.USP_DATALIST_WEALTHINFORMATIONDASHBOARDRESEARCHSUMMARY
                (
                    @CONSTITUENTID uniqueidentifier,
                    @ISVISIBLE bit = 1
                )
                as
                    set nocount on;

                    if @ISVISIBLE = 1
                    begin
            select
              P.ID,
              P.RESEARCHSUMMARY
            from 
              dbo.CONSTITUENT C
                            left outer join dbo.PROSPECT P on P.ID = C.ID
            where
                            C.ID = @CONSTITUENTID;
                    end
                    else
                    begin
                        select top 1
              P.ID,
              P.RESEARCHSUMMARY
            from 
              dbo.CONSTITUENT C
                            left outer join dbo.PROSPECT P on P.ID = C.ID
            where
                            C.ID = @CONSTITUENTID;
                    end