Show TOC Start of Content Area

Background documentation JDOQL Operators  Locate the document in its SAP Library structure

The following table defines the operators that can be used in a JDOQL query, as well as the supported types for each of them:

Supported JDOQL Operators

Operator

Description

Supported Types

==

Equal

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger Boolean, boolean, Date, any class instance or array

!=

Not equal

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger Boolean, boolean, Date, any class instance or array

>

Greater than

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger, Date, String

<

Less than

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger, Date, String

>=

Greater than or equal

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger, Date, String

<=

Less than or equal

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger, Date, String

&

Boolean logical AND (not bitwise)

Boolean, boolean

&&

Conditional AND

Boolean, boolean

|

Boolean logical OR (not bitwise)

Boolean, boolean

||

Conditional OR

Boolean, boolean

!

NOT

Boolean, boolean

+

Addition or String concatenation

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger

String

-

Subtraction

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger

*

Multiplication

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger

/

Division

byte, short, int, long, char, Byte, Short, Integer, Long, Character float, double, Float, Double, BigDecimal, BigInteger

 

 

 

 

End of Content Area