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