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
