CODEWITHSUNDEEP
in-operatorrightnow-crmnegative-integerroql
Venkatesh
Venkatesh

Reputation: 1

In operator with one or More negative values not working with API Version 1.4 for Oracle Service Cloud

We have upgraded our application to use API version 1.4 and we observed the following error when ROQL query contains “in operator” with one or more negative values in the “in clause”. If all the values in the in clause are positive then this error is not occurring.

When we use API version 1.2, In clause with negative values is working fine without any exception. Is this intentional change in API version 1.4 or a regression introduced in version 1.4? Or we need to change the SOAP Request in some way?

The following is the ROQL query example.

USE operational; 
SELECT ovs2.ITABLE.ID, ovs2.ITABLE.INTEGERCOL FROM ovs2.ITABLE WHERE (ovs2$ITABLE.INTEGERCOL IN **(-2,4)**)

Exception received :

 WHERE clause contains mismatched data types in comparison

Upvotes: 0

Views: 110

Answers (0)

Related Questions