Home > Forum > Actions > Delete attachments with binary data

Delete attachments with binary data
0

Hi everyone!

Is there a standardized way to remove binary data from the ATF_Value column in attachments?

This column displays values like 0x[…] whenever an attachment exists on the form. However, when we delete the attachment manually, the binary data is still visible because it’s stored in the element’s history logs.

When I use the Delete attachments action with the options “all” and “delete attachments and all historical binary data”, it correctly removes the attachments and clears the data from this column — but only if the attachment is still present on the form.
If the attachment is deleted manually first, and then the action is triggered, the binary data in this column is not removed.

Does anyone know a simple way to delete this binary data?

WEBCON

Hi Cezary,

Unfortunately there isn't a simple way. Once an attachment is removed, it is flagged as deleted in the database and further actions do not operate on it.
The functionality to remove binary data of deleted attachments is in backlog and I hope it will be implemented sooner than later.
As a workaround, advanced users may want to manually update ATF_Value to empty string or change ATT_IsDeleted to 0 and then execute an action again.