JordanMcAlister
6 years agoQrew Captain
Mass Delete Attachments based on criteria
I just set up a way to delete attachments for future status changes that works off of an automation and a webhook which I had to do because within 2 months, my table had reached 80 GB, so now, whenever the status of a Job reaches "CLOSED" all the pictures associated will be deleted. The thing I need to do now is delete all the picture files of Jobs that are already CLOSED before I set up the status change automation. For all the jobs that are already closed, there will be no change that happens to them that I could use an automation to delete the files, so I was wondering if there is a work around for this? Do I need to make some sort of change that affects all records then use an automation that has a check if records are closed then delete files from there? Will I run into an error if there are too many files that would be deleted from an automation?
Thanks for any help on this
------------------------------
Jordan McAlister
------------------------------
Thanks for any help on this
------------------------------
Jordan McAlister
------------------------------