cancel
Showing results for 
Search instead for 
Did you mean: 

Parameter field with multiple values is not working in SQL query Command

Former Member
0 Kudos

Setup a Parameter field with multiple values to be used in a SQL query command and it does not work when more than one value is selected, but works fine with one value selected. And yes, the "Allow multiple values" flag is set to True under Options.

I am trying to go from this:

  EMPBNFIT.BENEFITPLAN in ('CONSUMER CHOICE','HMO', 'HS HMO','HS NETWORK CHOICE','HS PPO BASIC NH RPN','HS PPO PLUS NH RPN','MFS CONSUMER CHOICE','NETWORK CHOICE','PPO BASIC NH RPN','PPO PLUS NH RPN','WAIVE MEDICAL')

to this:

  WHERE EMPBNFIT.BENEFITPLAN in ('{?MyPlans}')

capture.png capture1.png

Accepted Solutions (0)

Answers (2)

Answers (2)

abhilash_kumar
Active Contributor
0 Kudos

Hi Pat,

This looks like a SQL Server database?

If yes, change the where clause to:

WHERE EMPBNFIT.BENEFITPLAN in {?MyPlans}

-Abhilash

vitaly_izmaylov
Employee
Employee
0 Kudos