FROM Clause

aggregate_expression

boolean_expression ::= boolean_primary | (subquery)

boolean_primary ::=

state_field_path_expression |

boolean_literal |

input_parameter

enum_expression ::= enum_primary | (subquery)

enum_primary ::=

state_field_path_expression |

enum_literal |

input_parameter

entity_expression ::=

single_valued_association_path_expression |

simple_entity_expression

simple_entity_expression ::=

identification_variable |

input_parameter

functions_returning_numerics::=

LENGTH(string_primary) |

LOCATE(string_primary, string_primary[,

simple_arithmetic_expression]) |

ABS(simple_arithmetic_expression) |

SQRT(simple_arithmetic_expression) |

MOD(simple_arithmetic_expression,

simple_arithmetic_expression) |

SIZE(collection_valued_path_expression)

functions_returning_datetime ::=

CURRENT_DATE |

CURRENT_TIME |

CURRENT_TIMESTAMP

functions_returning_strings ::=

CONCAT(string_primary, string_primary) |

SUBSTRING(string_primary,

simple_arithmetic_expression,

simple_arithmetic_expression)|

TRIM([[trim_specification] [trim_character] FROM]

string_primary) |

LOWER(string_primary) |

UPPER(string_primary)

trim_specification ::= LEADING | TRAILING | BOTH

FROM

Clause

The FROM clause defines the domain of the query by declaring identification variables.

Full Query Language Syntax

Chapter 27 · The Java Persistence Query Language

745