AnsweredAssumed Answered

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

Question asked by gow_j on Jul 11, 2016

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

Outcomes