AnsweredAssumed Answered

How to use OR condition in two multi select filter?

Question asked by ManasBagde on Feb 3, 2016
Latest reply on Feb 3, 2016 by Dave_3.0

Hi All,



I have requirement to add couple of multi select filters in my portlet.



Ex: If i select A, B values in filter1 and X, Y values in filter2 then output should fetch all results. Meaning we should be able to fetch filter1 or filter2 data (but not filter1 AND filter2).



If i use the below code snippet then portlet is not considering these filters at all and showing the full resultset (Show All data).



WHERE ((A.dept_role_id IS NULL) OR (@WHERE:PARAM:USER_DEF:INTEGER:A.dept_role_id:role_vendor@))

OR ((A.role_cc_id IS NULL) OR (@WHERE:PARAM:USER_DEF:INTEGER:A.role_cc_id:role_cc@))



But If i apply additional open and close brace in the condition then portlet is considering the filter condition as AND even though i have written OR in the filter.



WHERE (((A.dept_role_id IS NULL) OR (@WHERE:PARAM:USER_DEF:INTEGER:A.dept_role_id:role_vendor@))

OR ((A.role_cc_id IS NULL) OR (@WHERE:PARAM:USER_DEF:INTEGER:A.role_cc_id:role_cc@)))





Any workaround for this? If any one has already used OR condition in between two multi select filters please share the thoughts.



Thanks in advance.