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.

 

 

Regards,

Manas

Outcomes