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.

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings