Not applicable

Set the T-SQL IN() clause with a workflow variable

I am retrieving values from a separate list and putting them into a string workflow variable, and then attempting to use that workflow variable as the parameter in the IN() clause inside.

query.PNG

I can confirm that it's successfully populating the variable as intended via log in history

invalues.PNG

This is the error I get.  It's almost like it doesn't recognize anything after the first coma?  I've tried both a single and multi line text variable.

error.PNG

Has anyone tried setting the IN() clause with a workflow variable?  The list is to be dynamic and the goal is to have that separate list queried each time this workflow runs (quarterly) instead of having to update the workflow with the new numbers each time.

Thanks in advance,

Jeff

Reply