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.

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.