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!

[BMellert]

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%%' ")