Home > Forum > General > Run SQL procedure action

Run SQL procedure action
0

Hello,
I have a question, a curiosity...
In the WFDataAttachmets table, there is a column called ATT_IsDeleted. If I want to Run SQL procedure (webcon action) and update table and set the ATT_IsDeleted column with 1 or 0.
Is it a good practice? Or is it not allowed?

Thanks.

MVP

Hi,
This approach is not recommended. Additionally,
the attached data is stored in the [dbo].[WFAttachmentFiles] table within the attachment database linked to the process.
If you occasionally need to restore a deleted attachment, it's advisable to download its latest version from the history in administrative mode and re-add it 'normally'.
However, if this situation occurs frequently, I strongly advise reassessing your process and finding an alternative solution to meet this requirement.
e.g. using API

Regards.