USP_DATALIST_EVENTPROFILEREPORT_NOTE

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

                    if @ISVISIBLE = 1
                    begin

                        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);

                        select
                            NOTETYPE.DESCRIPTION as NOTETYPE,
                            NOTE.TITLE,
                            NOTE.DATEENTERED,
                            NF.NAME as AUTHOR,
                            NOTE.TEXTNOTE
                        from
                            dbo.EVENTNOTE NOTE
                        inner join
                            dbo.EVENTNOTETYPECODE NOTETYPE on NOTE.EVENTNOTETYPECODEID = NOTETYPE.ID
                        left join
                            dbo.CONSTITUENT on (NOTE.AUTHORID = CONSTITUENT.ID)
                                                and (@ISADMIN = 1 or 
                                                    @APPUSER_IN_NONRACROLE = 1 or
                                                    dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, CONSTITUENT.ID, @APPUSER_IN_NOSECGROUPROLE) = 1)
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF                        
                        where
                            NOTE.EVENTID = @EVENTID
                        order by 
                            NOTETYPE.DESCRIPTION, NOTE.TITLE;
                    end