You are viewing limited content. For full access, please sign in.

Question

Question

Workflow - How to use Custom Query

asked on August 29, 2016

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.

 

 

Screenshot.JPG
Screenshot.JPG (188.39 KB)
0 0

Replies

replied on August 29, 2016 Show version history

hello Jeson

please follow as per the screenshots.

for more information please follow this guide line

    1. Type your Parameter Name under Parameter Names. How to specify the parameter names depends on how you are connecting to the data source:

      • When using an ODBC connection, you cannot use named parameters. Use "?" for each parameter name. They are interpreted in the order in which they are listed. ClosedShow me what this looks like. You must list a parameter each time you use one in the query, even if you use the same parameter twice in the same query.
      • With any other type of connection, use the naming convention specific to that connection. Named parameters can be used more than once in the query without being listed more than once in the parameter list. ClosedShow me what this looks like.

source link : https://www.laserfiche.com/support/webhelp/workflow/9.2/en-us/LFWorkflow.htm#cshid=Resources/Activities/Custom%20Query.htm

regards

Mazahir Naya

6 0
replied on August 30, 2016

LF workflow has not inherent tool to delete a record from a Sql table. You will need Scripting to accomplish that.

0 0
replied on August 30, 2016

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.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.