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 |