Hello can some please assist if they have experienced the same situation:
Issue: When searching using the OPBetween operator it throws the below excpetion
ODException: com.ibm.edms.od.ODException: Invalid operator
id = 0
msg = Invalid operator
com.ibm.edms.od.ODException: Invalid operator
at com.ibm.edms.od.ODCriteria.setOperator(ODCriteria.java:404)
at com.dev.cmod.TcSearch.main(TcSearch.java:130)
at com.dev.code.RestClient.<init>(RestClient.java:56)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
We are receiving this when setting the search operators as per the link:
https://www.ibm.com/support/knowledgecenter/en/SSEPCD_9.5.0/com.ibm.ondemand.odwek.doc/dodwj018.htm System.out.println( "Setting operator to " + operator + "..." );
if ( operator.equals( "eq" ) )
opr = ODConstant.OPEqual;
else if ( operator.equals( "ne" ) )
opr = ODConstant.OPNotEqual;
else if ( operator.equals( "lt" ) )
opr = ODConstant.OPLessThan;
else if ( operator.equals( "le" ) )
opr = ODConstant.OPLessThanEqual;
else if ( operator.equals( "gt" ) )
opr = ODConstant.OPGreaterThan;
else if ( operator.equals( "ge" ) )
opr = ODConstant.OPGreaterThanEqual;
else if ( operator.equals( "in" ) )
opr = ODConstant.OPIn;
else if ( operator.equals( "ni" ) )
opr = ODConstant.OPNotIn;
else if ( operator.equals( "li" ) )
opr = ODConstant.OPLike;
else if ( operator.equals( "nl" ) )
opr = ODConstant.OPNotLike;
else if ( operator.equals( "be" ) )
opr = ODConstant.OPBetween;
else if ( operator.equals( "nb" ) )
opr = ODConstant.OPNotBetween;
else opr = -1;
The between operator fails.
Thank you
Nishen