Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 31, 2017 at 10:05 AM

    Hi Pat,

    This looks like a SQL Server database?

    If yes, change the where clause to:

    WHERE EMPBNFIT.BENEFITPLAN in {?MyPlans}

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 27, 2017 at 08:25 PM
    Add comment
    10|10000 characters needed characters exceeded