Is it possible to enter multiple values in an Automation script field prompting for a varaible value? (4244894)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Is it possible to enter multiple values in an Automation script field prompting for a varaible value?
Description

An automation script runs fine when users enter a single value for the variable when prompted. However, if the user enters two or more numbers (separated by a comma), the query fails with an "Invalid Number" error. Is there a way to enter multiple values in the variable field?
Cause

An IN statement needs to be used in the query. Bind variables, in general, do not work with multiple values, so that cannot be done.
Resolution

Using multiple values can be accomplished by using an IN statement and bind literals in automation and replace the entire IN clause.
The variable would be…

a
string type
value = (1,2,3) note: include the parentheses

SQL would be like below. At run time the #a# will be replaced with the (1,2,3)

select * from ADDRESS
where region_id IN #a#

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title