We have an invoice form where people enter the data and then attach a file. All the info is sent via email through to accounts and after a month we remove the form submissions. I noticed the attachments are still sitting in the submissions folder, even though the original form submissions have been removed.
What do other people do to remove these attachments (via a script or sql I don't want to have to drag attachments to trash)? Would a trigger to set the future lineage to trash running 30 days after the original submission work.
Will a delete from sq_ast table get them out of the system completely or are they stored on the file system somewhere else?
Removing form submission attachments
mitch
(Mitchell Essex)
#1
dnw
(David Wallace)
#2
Hi Mitch
Did you ever get this solved?
I have exactly the same problem where for security reasons I need to delete attachments.
TIA