About query

21-30 of 200Refresh
JPA Doc
202

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query Variables The FROM clause in JPA queries (as in SQL) defines the query variables. Query variables are represented in criteria queries by descendant interfaces of the From interface: Range variables
JPA Doc
202

Criteria Query Selection and Results

clauses and for representing query results as tuples. SELECT Clause Elements The content of the SELECT clause in a criteria query is represented by Selection: Because Selection is a super interface ... : See the SELECT in Criteria Queries section for more details and examples. ORDER BY Clause Elements Elements in
Manual
200

Date and Time in JPQL and Criteria Queries [2011-09-20]

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12 ... that are evaluated to the date and time on the database server when the query is executed: CURRENT_DATE ... in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date
Manual
200

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12 ... that are evaluated to the date and time on the database server when the query is executed: CURRENT_DATE ... in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date
Manual
197

Literals in JPQL and Criteria Queries [2011-09-20]

literals should be used sparingly as queries that use parameters instead of literals ... values. Literals should only be embedded in JPQL queries when a single constant value is always used ... adds support for enum literals. Enum literals in JPQL queries use the ordinary Java syntax for enum
Manual
197

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments ... , which should be used for checking other collections, such as a collection that is passed to the query ... of collection, so in ObjectDB these operators are treated as synonyms. Criteria Query Collection
Manual
197

Literals in JPQL and Criteria Queries

literals should be used sparingly as queries that use parameters instead of literals ... values. Literals should only be embedded in JPQL queries when a single constant value is always used ... support for enum literals. Enum literals in JPQL queries use the ordinary Java syntax for enum
JPA Doc
196

JPA Annotations for JPQL Queries

The following annotations are used to define static named JPA queries: The JPA Named Queries section of the ObjectDB Manual explains and demonstrates how to use these annotations to define named JPQL queries.
Manual
196

Numbers in JPQL and Criteria Queries [2011-09-20]

Numeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as ... of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL arithmetic operators and functions (which are described above) are available also as JPA criteria query
Manual
196

Strings in JPQL and Criteria Queries [2019-08-03]

String values may appear in JPQL queries in various forms: as string literals - e.g. 'abc', ''. as ... operator). Criteria Query String Expressions JPQL string operators and functions (which are described above) are available also as JPA criteria query expressions. The CriteriaBuilder interface provides