I got the query by enabling the jdbc log in WB, but this Query is not useful for me, Let me state my requirement here. I have a portlet, I am having a filter field, I want to make this filter field multiselect, if I give single value in the filter I am getting output in the portlet, if I give more than one value it is not returning any rows.
I saw the executed portlet query and I saw the multiselect line like this
AND O.ORG_UNIT_NAME = 'Test1,Test2'
How can I modify my data source such that the query will become
I'm kind of confused now about what you're trying to do.
This query is returning a lot of fields, and it's pretty much guaranteed that some (or all) of the values will be different for each request_id. That's why the error - SQL can't know which ones to return for a given request_id.
Can you maybe restate what it is you're trying to do, with a simple example?