cancel
Showing results for 
Search instead for 
Did you mean: 

Multi-Selection Issues

Former Member
0 Kudos

I have created a Command that pulls in data from Oracle. It is just a SQL statement at you will see below. It contains 1 parameter andI would like this parameter to be multi-valued, but it is not working. Below is the query. I am tried to have the users put in values such as 1,2,3 and just using the built-in shuttle, but neither of them work. Having using put in a comma deleimted string such as 1,2,3 gives me an invalid number error. Any ideas on how I can pass a multi-valued selection to my query below? Thank you very much. 

SELECT  (lname||', '||fname||' '||mname) AS Name
        ,TO_CHAR(corp) AS CORP
        ,TO_CHAR(center) AS CENTER
        ,TO_CHAR(dob,'MM-DD') AS DOB
       ,ACCT_UNIT_LAWSON
FROM    humrec2.emprofile
WHERE   corp='10'
        AND empstatus = '1'
        AND year = TO_CHAR(sysdate,'yyyy')

       AND (INSTR(','||{?ACCTUNIT}||',', ','||ACCT_UNIT_LAWSON||',') > 0)

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello,

CR doesn't modify the SQL in a Command object so you have to enter the values in a format that Oracle will understand them.

You can do the same in CR Parameters when setting it to a Dynamic List and then populate that list, if it's a static list it works great. but it may be client side filtering.

Try it to see if that would work, you have to create a new report. If you use your command object without the that specific parameter it will end up bring in all data.

Don