Charge codes and transaction classes filtering

Discussion created by georges.barakeh on Nov 13, 2014
Latest reply on Feb 6, 2015 by

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.