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

Question

How to pass a multivalued token of strings to a MSSQL stored procedure

Workflow Version 10 How To

Updated March 30, 2021

asked on March 26, 2021 • Show version history

I have a form with a table of values that the user can select from using a checkbox. When Workflow processes the table I select the checked values and store them in a multi-valued token. So far, so good. How do I pass this to a stored procedure? Would I declare an input parameter of type table?

0 0

Replies

replied on March 30, 2021

What I ended up doing was passing the table as a concatenated string with a special character as a separator, and then using the split_string function to turn it into a table of values again on the SQL side.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked March 26, 2021
Updated March 30, 2021
64 views