Multi-Select Fields in Portlet

[Anusha Subbarao]

We are trying to create a multiselect field in  portlet using the below condition in WHERE clause:
" SRM.FULL_NAME =NVL(@WHERE:PARAM:USER_DEF:string:MANAGER_NAME@,SRM.FULL_NAME)"

It seems that filter is not working, it simply displays all records while any values are slected.
Any help is appreciated.
Thanks in Advance

[David Morton]

If you return the the manager id in the data in your query and then use that field (associated with a lookup) in the filter in your portlet then it should work "properly" as a multi-select.

I recall that it is very hard to get "WHERE:PARAM" type fields to work multi-select - if you "preview" the NSQL you will see why that is, i.e. how the SQL is built based on your parameter, it is probably not how you expect it.