ObjectDB ObjectDB

Internal Website Search

1-10 of 172 resultsRefresh
321

GROUP BY and HAVING clauses

with HAVING Groups in JPQL grouping queries can be filtered using the HAVING clause. The HAVING clause for the GROUP BY clause is like the WHERE clause for the FROM clause. ObjectDB supports the HAVING clause only when a GROUP BY clause exists. The following query uses HAVING to change the previous
134

New to Product & Having An Issue

New to Product & Having An Issue
134

URGENCY, or in query does not report any objects on first operand having no results

URGENCY, or in query does not report any objects on first operand having no results
85

having(restriction)

Method javax.persistence.criteria.AbstractQuery AbstractQuery<T> having( Expression<Boolean> restriction ) Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any. Parameters: restriction - a simple or compound boolean expression Returns: the modified query Since: JPA 2.0
85

having(restrictions)

Method javax.persistence.criteria.AbstractQuery AbstractQuery<T> having( Predicate... restrictions ) Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates. Replaces the previously having added restriction(s), if any. If no restrictions
85

having(restrictions)

Method javax.persistence.criteria.Subquery Subquery<T> having( Predicate... restrictions ) Specify restrictions over the groups of the subquery according the conjunction of the specified restriction predicates. Replaces the previously added having restriction(s), if any. If no restrictions
85

having(restriction)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery<T> having( Expression<Boolean> restriction ) Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method
85

having(restrictions)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery<T> having( Predicate... restrictions ) Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates. Replaces the previously added having restriction(s), if any. If no restrictions
85

having(restriction)

Method javax.persistence.criteria.Subquery Subquery<T> having( Expression<Boolean> restriction ) Specify a restriction over the groups of the subquery. Replaces the previous having restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method
27

JPA Query Structure (JPQL / Criteria)

. Having an SQL-like syntax in JPA queries is an important advantage because SQL is a very powerful query ... of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ... , HAVING and ORDER BY are optional. The structure of JPQL DELETE and UPDATE queries is simpler: DELETE

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support