multi select on multi valued looku

[Hima Bindu Boggavarapu]

I have added a multi valued lookup attribute to project object wherein I can select multiple resources in it.

 

I am able to add to query to display values , but am stuck in adding filter to that attribute in a portlet.

 

Here is my query to dislay the names in the field, I want to add multi select filter on srm.id

 

select pk_id, listagg((srm.first_name || ' ' || srm.last_name), ',') within group (order by mul.seq) stake

 

 

 jOIN srm_resources srm ON srm.id=mul.value

 

  WHERE object= 'project' AND ATTRIBUTE ='key_stake'

  GROUP BY pk_id