Skip Headers

# Expression Options for In-Memory Queries

Previous

Next

You can use a subset of `Expression` (see Table: Expressions Operator Support for In-Memory Queries) and `ExpressionMath` (see Table: ExpressionMath Operator Support for In-Memory Queries) methods with in-memory queries. For more information about these options, see "Understanding TopLink Expressions".

Expressions Operator Support for In-Memory Queries

Expressions Operator | In-Memory Query Support
--- | ---
`addMonths` |
`and` |
`anyof` Foot 1 |
`anyofAllowingNone` Footref 1 |
`asciiValue` |
`between` |
`concat` |
`currentDate` |
`dateToString` |
`decode` |
`equal` |
`get` Footref 1 |
`getAllowingNull` Footref 1 |
`getFunction` |
`greaterThan` |
`greaterThanEqual` |
`hexToRaw` |
`ifNull` |
`in` |
`isNull` |
`lastDay` |
`leftPad` |
`leftTrim` |
`length` |
`lessThan` |
`lessThanEqual` |
`like` |
`monthsBetween` |
`newTime` |
`nextDay` |
`notBetween` |
`notIn` |
`notIn` |
`notNull` |
`or` |
`ref` |
`replace` |
`rightPad` |
`rightTrim` |
`subQuery` |
`substring` |
`toCharacter` |
`toDate` |
`toLowerCase` |
`toNumber` |
`toUpperCase` |
`toUpperCasedWords` |
`translate` |
`trim` |
`truncateDate` |

Footnote 1 For more information, see "Join Reading and Object-Level Read Queries".

ExpressionMath Operator Support for In-Memory Queries

ExpressionMath Operator | In-Memory Query Support
--- | ---
`abs` |
`acos` |
`add` |
`asin` |
`atan` |
`atan2` |
`ceil` |
`chr` |
`cos` |
`cosh` |
`exp` |
`floor` |
`ln` |
`log` |
`max` |
`min` |
`mod` |
`none` |
`power` |
`round` |
`sign` |
`sin` |
`sinh` |
`sqrt` |
`subtract` |
`tan` |
`tanh` |
`trunc` |