Skip to Content
1
Former Member
Aug 06, 2016 at 06:27 PM

flexible search query parameter for list of product codes

9056 Views

Hi, I want to run a flexible search query in Dao class. I have tested that query through HAC, it works fine. The query is : select * from {product} where {code} in ('1000', '2000', '3000'). To dao class, I am passing the query parameter productCodes as string variable with value as "1000,2000,3000". The query returns me zero results as I believe whole string is considered as one product code. if I pass single product code it works. Eg: "1000". So how can I pass the list of product codes as query parameter?

Thanks in advance