USP_DATALIST_CONSTITUENTPROFILEDASHBOARDNOTES

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDNOTES
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1,
                        @CURRENTAPPUSERID uniqueidentifier
                    )
                    as
                        set nocount on;

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

                        set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);                  
                        if @ISADMIN <> 1 begin 
                            set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);
                            if @APPUSER_IN_NONRACROLE <> 1
                                set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);
                        end

                        if @ISVISIBLE = 1
                        begin
                            select
                                CONSTITUENTNOTE.TITLE,
                                CONSTITUENTNOTE.DATEENTERED,
                                CONSTITUENTNOTE.TEXTNOTE,
                                NF.NAME as AUTHOR,
                                CONSTITUENTNOTETYPECODE.DESCRIPTION as TYPE
                            from 
                                dbo.CONSTITUENTNOTE
                            left outer join 
                                dbo.CONSTITUENTNOTETYPECODE on CONSTITUENTNOTETYPECODE.ID = CONSTITUENTNOTE.CONSTITUENTNOTETYPECODEID
                            left outer join 
                                dbo.CONSTITUENT on CONSTITUENT.ID = CONSTITUENTNOTE.AUTHORID
                                and (@ISADMIN = 1 or 
                                    @APPUSER_IN_NONRACROLE = 1 or
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, CONSTITUENTNOTE.AUTHORID, @APPUSER_IN_NOSECGROUPROLE) = 1)
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                            where 
                                CONSTITUENTNOTE.CONSTITUENTID = @CONSTITUENTID
                            and
                                (@ISADMIN = 1 or dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRY(@CURRENTAPPUSERID,CONSTITUENTNOTETYPECODE.ID) = 1)
                            order by
                                TYPE,
                                CONSTITUENTNOTE.TITLE,
                                CONSTITUENTNOTE.DATEENTERED;
                        end