Passing Multiple Values in Input Parameters

[Former Member]

Hi,

I have created a graphical calculation view say 'A' with VAR_CUSTOMER_NAME (on column CUSTOMER_NAME).

Here IP - Input Parameter and VAR - Variable.

I have created another scripted calculation view say 'B' with IP_CUSTOMER_NAME.

I have used this calculation view 'A' in 'B' in the following way

var_out =  select COMPANY_NAME from A

                 where CUSTOMER_NAME in (:IP_CUSTOMER_NAME)

Requirement:

I need to pass multiple values to the IP_CUSTOMER_NAME in B and hence the values are filtered accordingly in A.

Note: I have made IP_CUSTOMER_NAME and VAR_CUSTOMER_NAME as a single value with multiple entries.

I tried the following, but it didn't work.

SELECT COMPANY_NAME

FROM B

('PLACEHOLDER' = ('$$IP_CUSTOMER_NAME$$', 'Adam","Ian'))

and

SELECT COMPANY_NAME

FROM B

('PLACEHOLDER' = ('$$IP_CUSTOMER_NAME$$', 'Adam','Ian'))

Kindly some one help me with the same.

Regards,

Monissha

[Former Member]

Hi Monissha,

         this will work for you

SELECT COMPANY_NAME

FROM B

(

   'PLACEHOLDER' = ('$$IP_CUSTOMER_NAME$$', 'Adam',),

   'PLACEHOLDER' = ('$$IP_CUSTOMER_NAME$$', 'Ian')

);

All the Best

Nagababu Tubati