Hi All,
I need some guidance on using custom query in workflow.
I trying to use custom query to delete a record from my database table. But i not sure on the configuration. I had attached a screenshot of my workflow.
Thank you.
Hi All,
I need some guidance on using custom query in workflow.
I trying to use custom query to delete a record from my database table. But i not sure on the configuration. I had attached a screenshot of my workflow.
Thank you.
hello Jeson
please follow as per the screenshots.
for more information please follow this guide line
source link : https://www.laserfiche.com/support/webhelp/workflow/9.2/en-us/LFWorkflow.htm#cshid=Resources/Activities/Custom%20Query.htm
regards
Mazahir Naya
LF workflow has not inherent tool to delete a record from a Sql table. You will need Scripting to accomplish that.
You're using a select query. That's for reading data from a table. You'll need to issue a deletestatement if you want to delete rows from a table. Make sure you have the correct WHERE clause in it or it may delete the entire contents of the table.