AnsweredAssumed Answered

Can you use a list for the value for the database parameter on the connector?

Question asked by ChadWatson7251 on Mar 4, 2016
Latest reply on Mar 10, 2016 by ChadWatson7251

I know how to use the parameters on the database connector if I'm setting it to equal one value.

Like:   select * from mytable where columnA = ?

and the ? = a single value like 10.

 

Can you set the parameter to a list?  If so what would the format be for the list?

Essentially making it an IN statement for the where clause.

Like: select * from mytable where columnA in ?

and the ? = '10 ,12'

 

Here is the help - only specifies how to use it with a single value, not a list

To Add Parametersto a Database Profile

Outcomes