Question

workflow custom query parameter

Workflow Version 9

Updated March 15, 2016

asked on March 15, 2016

hi to all

i am facing one problem in Workflow Custom Query when i try my parameter with ? it is working fine but when instead of ? if i use parameter name ex: to_date , From_date i am getting error.

Error

help me to solve this issue.

Thank You.

0 0

Answer

SELECTED ANSWER

replied on March 15, 2016

hi Mike

i found the Answer from Help file. Link :-https://www.laserfiche.com/support/webhelp/workflow/9.2/en-us/LFWorkflow.htm#cshid=Resources/Activities/Custom%20Query.htm

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. Show 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. Show me what this looks like.

Thank You.

Best Regards

Mazahir Naya

2 0

Replies

replied on March 15, 2016

Yes, you have to use the ?

So your query would look like this...

1 0

replied on March 15, 2016

Thanks Mike for reply but why only "?" work ?

0 0

You are not allowed to follow up in this post.

Question

Question

workflow custom query parameter

Answer

Replies

Sign in to reply to this post.