on 02-11-2014 6:49 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.