USP_DATALIST_WEALTHINFORMATIONDASHBOARDINTERESTS

This datalist returns interest information that is used by the prospect research dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ISVISIBLE	bit	IN	Visible
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



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


                    declare @ISADMIN bit;
                    declare @APPUSER_IN_NONRACROLE bit;
                    declare @APPUSER_IN_NOSECGROUPROLE bit;

                    set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);
                    set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);
                    set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);

                        if @ISVISIBLE = 1
                        begin
                            select
                                i.NOTE,
                cic.DESCRIPTION as TYPE
                            from
                                dbo.CONSTITUENTINTEREST i
                left outer join dbo.CONSTITUENTINTERESTCODE cic 
                  on i.CONSTITUENTINTERESTCODEID = cic.ID
              where 
                i.CONSTITUENTID = @CONSTITUENTID 
                and (@ISADMIN = 1 or 
                              @APPUSER_IN_NONRACROLE = 1 or
                              dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, @CONSTITUENTID, @APPUSER_IN_NOSECGROUPROLE) = 1)
              order by
                                TYPE;
                        end
                        else
                        begin
                            select top 1
                                i.NOTE,
                cic.DESCRIPTION as TYPE
                            from
                                dbo.CONSTITUENTINTEREST i
                left outer join dbo.CONSTITUENTINTERESTCODE cic 
                  on i.CONSTITUENTINTERESTCODEID = cic.ID
              where 
                i.CONSTITUENTID = @CONSTITUENTID
              order by
                                TYPE;
                        end