USP_DATALIST_WEALTHINFORMATIONDASHBOARDNOTE

This datalist returns WealthPiont notes information that is used by the wealth information 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_WEALTHINFORMATIONDASHBOARDNOTE
                (
                    @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 
                            n.TITLE,
                            NF.NAME,
                            n.TEXTNOTE,
                            n.DATEENTERED as DATEADDED,
                            n.DATECHANGED,
              n.HTMLNOTE,
              dbo.UFN_CONSTITUENTNOTETYPECODE_GETDESCRIPTION(n.CONSTITUENTNOTETYPECODEID) as TYPE
                        from
                            dbo.CONSTITUENTNOTE n
                        left outer join dbo.CONSTITUENT c
                            on c.ID = n.AUTHORID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(c.ID) NF
                        where
                            CONSTITUENTID = @CONSTITUENTID
                            and (@ISADMIN = 1 or 
                                @APPUSER_IN_NONRACROLE = 1 or
                                dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, CONSTITUENTID, @APPUSER_IN_NOSECGROUPROLE) = 1);                                
                    end
                    else
                    begin
                        select top 1
                            n.TITLE,
                            NF.NAME,
                            n.TEXTNOTE,
                            n.DATEENTERED as DATEADDED,
                            n.DATECHANGED,
              n.HTMLNOTE,
              dbo.UFN_CONSTITUENTNOTETYPECODE_GETDESCRIPTION(n.CONSTITUENTNOTETYPECODEID) as TYPE
                        from
                            dbo.CONSTITUENTNOTE n
                        left outer join dbo.CONSTITUENT c
                            on c.ID = n.AUTHORID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(c.ID) NF
                        where
                            CONSTITUENTID = @CONSTITUENTID;                                
                    end