Reference ZenDesk Ticket: 1950710
Description: While adding a note on IRP iZone in the Notepad module the agent accidentally appended the wrong note onto another members file.
Solution: The business side process is to open the notepad entry in question and within the "Add Comments" field they should state that the note on file can be ignored as it was accidently appended to the wrong member file number.
In the event the business really needs a Notepad entry removed the below process can be utilized
-- search notes based on member filename
select * from projnote where projectid='NRC 202100056'
-- to identify the record ID associated to the note you will need to check the date of the note and subject in iZone.
-- delete notes from member file using record ID
delete from projnote
where record_id= [record ID of the note] and projectid=;'NRC 202100056'