cancel
Showing results for 
Search instead for 
Did you mean: 

QUERY - How to use OR condition in a dynamic AND filter

Former Member
0 Kudos

Hi Experts,

How to use OR condition in a dynamic AND filter, like seen below :

<%AND_OP("UPPER(T8.PARENT_OBJECT_ID)",<%?(T8.OBJECTID)%> OR ("UPPER(T9.PARENT_OBJECT_ID)",<%?(T8.OBJECTID)%>)%>

When I try to do something like above I get error - SQL Exception: ORA-00933: SQL command not properly ended , ANSI-92 SQL State: 42000, Vendor Error Code: 933. ORA-00933: SQL command not properly ended

I want to input a value which I want to test against two fields and get the results, if any of one matches.

I request you to suggest if any one have come across such a situation and fixed it.

Any help appreciated.

Thanks,

Lava.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Lava,

You can alternatively use the below condition to achieve the same.

<%AND("(T8.PARENT_OBJECT_ID = <%?(T8.OBJECTID)%> OR T9.PARENT_OBJECT_ID = <%?(T8.OBJECTID)%>)")%>

Regards

Praveen


Answers (0)