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

Question

Question

How to pass a parameter to a Stored Procedure via Custom Query in Work Flow?

asked on March 12, 2021

How to pass a parameters to a Stored Procedure via Custom Query in Work Flow?

0 0

Answer

SELECTED ANSWER
replied on March 13, 2021

Maxwell,

Parameters are passed by referencing the stored procedure parameter name in the EXEC statement in the custom query.  In the example below I have a stored procedure named 'GetApplicationNumber' that has a single varchar(50) parameter named '@guid' and I am passing the value from a forms token to the stored procedure;

 

Note: The naming syntax for the Parameter Names in the custom query depend on how you configured the connection to the database.  In the example above I am using a direct SQL connection so my parameter is named, versus an ODBC connection where the parameter name would just be a '?'. 

See the help files here https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/#../Subsystems/LFWorkflow/Content/Resources%2FActivities%2FCustom%20Query.htm for additional information on custom query parameter naming syntax.

 

 

3 0
replied on March 15, 2021

Thank you! This helps me a lot :)

0 0

Replies

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

Sign in to reply to this post.