32 | Strings in JPQL and Criteria QueriesString 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 |
32 | Numbers in JPQL and Criteria QueriesNumeric 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 |
31 | Criteria Query ExpressionsThe following interfaces are in use in representing general expressions in criteria queries: See the Query Expressions section for more details and examples. |
31 | JPA Annotations for SQL QueriesThe following JPA annotations are designated for SQL queries on relational databases: ObjectDB supports only the preferred JPA query language, JPQL, and silently ignores all the above annotations. |
28 | Weird issue with variable naminghi, We've hit again against troubles with the variable naming when trying to get the query string ... us without ordering. The issue is that the name of the root variable is $1 as well as the name of our left join variable becomes $1. We're also adding a custom function expression in where clause |
2 | addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters) to this Query variableDeclaration - the name of the variable in the outer query to bind the results ... Method javax.jdo.Query void addSubquery( Query sub, String variableDeclaration, String candidateCollectionExpression, String... parameters ) Add a subquery to this query. A subquery is composed as |
2 | [ODB1] Chapter 9 - ObjectDB Explorer of the query. Optional JDOQL components, such as filter, parameters, variables, ordering and imports (chapter ... to browse databases, execute JDOQL queries, create new databases and edit the content of existing ... database objects visually, navigate among them and execute queries is very valuable during development |
2 | setFilter(filter) of the Query; and for all variables there exists a value for which the filter expression evaluates to true ... Method javax.jdo.Query void setFilter( String filter ) Set the filter for the query. The filter ... for the evaluation of the current set of variable values. Other values for variables might still qualify |
2 | executeWithArray(parameters)Method javax.jdo.Query Object executeWithArray( Object... parameters ) Execute the query and return the filtered Collection. The execution of the query obtains the values of the parameters ... , declared parameters, declared variables, and ordering statements are verified for consistency. Each element |
2 | addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters) variableDeclaration - the name of the variable to be used in this Query candidateCollectionExpression - the candidate ... Method javax.jdo.Query void addSubquery( Query sub, String variableDeclaration, String candidateCollectionExpression, Map parameters ) Add a subquery to this query. The Map version of the method |
