Hello,
I have one SQL Script Calculation View with one input parameter to filter the result by company. I want that input parameter accepts multiple entries, so i selected the Multiple Entries checkbox in Input Parameter Defenition window.
my code is something like this:
select *
from Table_A
where company in (:IP_COMPANY)
After i select the Multiple Entries checkbox and do the Data Preview the query doesn't return any result.
Even if i use the code with the filter company = IP_COMPANY and the Multiple Entries checkbox selected the query doesnt return data, only returns data with single value input parameter.
Can someone help me with this situation?
Best regards
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.