Is there anything special about these fields when it comes to filtering? I have created a custom portlet and I want to be able to filter on charge codes and transaction classes. I have these 2 fields linked to a lookup, when i filter, it doesnt filter correctly. When I use a parameter in my nsql (T1.chargecodeid = @WHERE:PARAM:USER_DEF:INTEGER:chargecode_id@) it works but but it won't allow multiple select to filter. multiple select filtering is mandatory, so if i need to go through the chargecode field it doesn't filter correct. Please note that my sql statement has UNION. Please help.