NoteDelete leaving orphan attachments
Description
When running NoteDelete (via scheduler or directly from Notice window) the AD_Note record is deleted, but the AD_Attachment record associated with the note is left in the database.
Indeed this is happening with any DELETE on the code.
Two suggestions:
1 - on NoteDelete, delete also the attachments associated to the notes being deleted
2 - create a CleanAttachment process that check for every AD_Attachment record if the parent still exists, otherwise delete it
Regards,
Carlos Ruiz
Environment
None
Activity
Show:
Carlos Ruiz
October 6, 2018, 9:43 PM
Created process "Clean Orphan Cascade Records"