Deleting multiple attachments

Nils Wyldbore

Hi,

 

Does anyone know of a neat way of deleting all attachments from a folder in a single script (server side jScript.Net)?

 

Is there a function to return an array of filenames? That way you could at least loop through this list and delete each attachment one at a time.

 

I'm developing a process that needs to remove all attachments before archiving and I cannot find a definitive way to do this without hacking the database directly.

 

Thanks for your help!

Brian Mellert

While not likely supported, I do something like this when we "copy folder" and we don't want the attachments in the new folder.  It has worked without issue for years.

%ExecSQL("DELETE FROM eAttachment WHERE eKey LIKE '%%%FolderID%%' ")