Skip to Content
0

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

Jul 27, 2017 at 08:15 PM

27

avatar image
Former Member

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

capture.png (63.5 kB)
capture1.png (43.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Jul 31, 2017 at 10:05 AM
0

Hi Pat,

This looks like a SQL Server database?

If yes, change the where clause to:

WHERE EMPBNFIT.BENEFITPLAN in {?MyPlans}

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Jul 27, 2017 at 08:25 PM
0
Share
10 |10000 characters needed characters left characters exceeded