Hibernate ORM - hibernate-core 6.4.4.Final · org.hibernate.query.sqm.tree.select.AbstractSqmSelectQuery

Modifier and Type	Field and Description
private final Map<String, SqmCteStatement<?>>	cteStatements
private Class<T>	resultType
private SqmQueryPart<T>	sqmQueryPart

Access	Constructor and Description
public	AbstractSqmSelectQuery(Class<T> resultType, NodeBuilder builder)
public	AbstractSqmSelectQuery(SqmQueryPart<T> queryPart, Class<T> resultType, NodeBuilder builder)
protected	AbstractSqmSelectQuery(NodeBuilder builder, Map<String, SqmCteStatement<?>> cteStatements, Class<T> resultType)
public	AbstractSqmSelectQuery(SqmQueryPart<T> queryPart, Map<String, SqmCteStatement<?>> cteStatements, Class<T> resultType, NodeBuilder builder)

Method Summary

Modifier and Type	Method and Description
private <X> SqmRoot<X>	addRoot(SqmRoot<X> root)
public void	appendHqlString(StringBuilder sb)
protected Map<String, SqmCteStatement<?>>	copyCteStatements(SqmCopyContext context)
public SqmSelectQuery<T>	distinct(boolean boolean value specifying whether duplicate results must be eliminated from the query result or whether they must be retained distinct) Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.distinct. Specify whether duplicate query results will be eliminated.
public <X> SqmRoot<X>	from(Class<X> the entity class entityClass) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots.
public <X> SqmDerivedRoot<X>	from(Subquery<X> the subquery subquery) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Create and add a query root corresponding to the given subquery, forming a cartesian product with any existing roots.
public <X> JpaRoot<X>	from(JpaCteCriteria<X> the cte criteria cte) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Create and add a query root corresponding to the given cte, forming a cartesian product with any existing roots.
public <X> SqmRoot<X>	from(EntityType<X> metamodel entity representing the entity of type X entityType) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots.
public <X> JpaCteCriteria<X>	getCteCriteria(String cteName) Implements org.hibernate.query.criteria.JpaCteContainer.getCteCriteria. Returns a CTE that is registered by the given name on this container, or any of its parents.
public Collection<? extends JpaCteCriteria<?>>	getCteCriterias() Implements org.hibernate.query.criteria.JpaCteContainer.getCteCriterias. Returns the CTEs that are registered on this container.
public SqmCteStatement<?>	getCteStatement(String cteLabel) Implements org.hibernate.query.sqm.tree.cte.SqmCteContainer.getCteStatement.
pack-priv Map<String, SqmCteStatement<?>>	getCteStatementMap()
public Collection<SqmCteStatement<?>>	getCteStatements() Implements org.hibernate.query.sqm.tree.cte.SqmCteContainer.getCteStatements.
public List<Expression<?>>	getGroupList() Implements jakarta.persistence.criteria.AbstractQuery.getGroupList. Return a list of the grouping expressions.
public SqmPredicate	getGroupRestriction() Implements org.hibernate.query.criteria.JpaSelectCriteria.getGroupRestriction. Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified.
public SqmQueryPart<T>	getQueryPart() Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.getQueryPart. The query structure.
public SqmQuerySpec<T>	getQuerySpec() Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.getQuerySpec. The query structure.
public SqmPredicate	getRestriction() Implements org.hibernate.query.criteria.JpaCriteriaBase.getRestriction, org.hibernate.query.criteria.JpaSelectCriteria.getRestriction. Return the predicate that corresponds to the where clause restriction(s), or null if no restrictions have been specified.
protected Selection<? extends T>	getResultSelection(Selection<?>[] selections)
public Class<T>	getResultType() Implements jakarta.persistence.criteria.AbstractQuery.getResultType. Return the result type of the query or subquery.
public List<Root<?>>	getRootList()
public Set<Root<?>>	getRoots() Implements jakarta.persistence.criteria.AbstractQuery.getRoots. Return the query roots.
public JpaSelection<T>	getSelection() Implements org.hibernate.query.criteria.JpaSelectCriteria.getSelection. Return the selection of the query, or null if no selection has been set.
public SqmSelectQuery<T>	groupBy(Expression<?>... zero or more grouping expressions expressions) Implements org.hibernate.query.criteria.JpaSelectCriteria.groupBy. Specify the expressions that are used to form groups over the query results.
public SqmSelectQuery<T>	groupBy(List<Expression<?>> list of zero or more grouping expressions grouping) Implements org.hibernate.query.criteria.JpaSelectCriteria.groupBy. Specify the expressions that are used to form groups over the query results.
public SqmSelectQuery<T>	having(Expression<Boolean> a simple or compound boolean expression booleanExpression) Implements org.hibernate.query.criteria.JpaSelectCriteria.having. Specify a restriction over the groups of the query.
public SqmSelectQuery<T>	having(Predicate... zero or more restriction predicates predicates) Implements org.hibernate.query.criteria.JpaSelectCriteria.having. Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates.
public boolean	isDistinct() Implements jakarta.persistence.criteria.AbstractQuery.isDistinct. Return whether duplicate query results must be eliminated or retained.
public void	setQueryPart(SqmQueryPart<T> sqmQueryPart)
protected void	setResultType(Class<T> resultType)
private void	validateComplianceFromSubQuery()
private String	validateCteName(String name)
public SqmSelectQuery<T>	where(Expression<Boolean> a simple or compound boolean expression restriction) Implements org.hibernate.query.criteria.JpaSelectCriteria.where. Modify the query to restrict the query results according to the specified boolean expression.
public SqmSelectQuery<T>	where(Predicate... zero or more restriction predicates restrictions) Implements org.hibernate.query.criteria.JpaSelectCriteria.where. Modify the query to restrict the query results according to the conjunction of the specified restriction predicates.
public <X> JpaCteCriteria<X>	with(AbstractQuery<X> criteria) Implements org.hibernate.query.criteria.JpaCteContainer.with. Registers the given `CriteriaQuery` and returns a `JpaCteCriteria`, which can be used for querying.
public <X> JpaCteCriteria<X>	with(String name, AbstractQuery<X> criteria) Implements org.hibernate.query.criteria.JpaCteContainer.with. Like `with(AbstractQuery)` but assigns an explicit CTE name.
private <X> JpaCteCriteria<X>	withInternal(String name, AbstractQuery<X> criteria)
private <X> JpaCteCriteria<X>	withInternal(String name, AbstractQuery<X> baseCriteria, boolean unionDistinct, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer)
public <X> JpaCteCriteria<X>	withRecursiveUnionAll(AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer) Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll. Allows to register a recursive CTE.
public <X> JpaCteCriteria<X>	withRecursiveUnionAll(String name, AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer) Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll. Like `withRecursiveUnionAll(AbstractQuery, Function)` but assigns an explicit CTE name.
public <X> JpaCteCriteria<X>	withRecursiveUnionDistinct(AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer) Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionDistinct. Allows to register a recursive CTE.
public <X> JpaCteCriteria<X>	withRecursiveUnionDistinct(String name, AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer) Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionDistinct. Like `withRecursiveUnionDistinct(AbstractQuery, Function)` but assigns an explicit CTE name.

Inherited from org.hibernate.query.sqm.tree.AbstractSqmNode:: nodeBuilder

cteStatements	back to summary
private final Map<String, SqmCteStatement<?>> cteStatements

resultType	back to summary
private Class<T> resultType

sqmQueryPart	back to summary
private SqmQueryPart<T> sqmQueryPart

AbstractSqmSelectQuery	back to summary
public AbstractSqmSelectQuery(Class<T> resultType, NodeBuilder builder)

AbstractSqmSelectQuery	back to summary
public AbstractSqmSelectQuery(SqmQueryPart<T> queryPart, Class<T> resultType, NodeBuilder builder)

AbstractSqmSelectQuery	back to summary
protected AbstractSqmSelectQuery(NodeBuilder builder, Map<String, SqmCteStatement<?>> cteStatements, Class<T> resultType)

AbstractSqmSelectQuery	back to summary
public AbstractSqmSelectQuery(SqmQueryPart<T> queryPart, Map<String, SqmCteStatement<?>> cteStatements, Class<T> resultType, NodeBuilder builder)

Method Detail

addRoot	back to summary
private <X> SqmRoot<X> addRoot(SqmRoot<X> root)

appendHqlString	back to summary
public void appendHqlString(StringBuilder sb)

copyCteStatements	back to summary
protected Map<String, SqmCteStatement<?>> copyCteStatements(SqmCopyContext context)

distinct	back to summary
public SqmSelectQuery<T> distinct(boolean distinct) Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.distinct. Doc from jakarta.persistence.criteria.AbstractQuery.distinct. Specify whether duplicate query results will be eliminated. A true value will cause duplicates to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained. Parameters distinct:boolean boolean value specifying whether duplicate results must be eliminated from the query result or whether they must be retained Returns:SqmSelectQuery<T> the modified query Annotations @Override

distinct

back to summary

public SqmSelectQuery<T> distinct(boolean distinct)

Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.distinct.

Doc from jakarta.persistence.criteria.AbstractQuery.distinct.

Specify whether duplicate query results will be eliminated. A true value will cause duplicates to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained.

Parameters

distinct:boolean: boolean value specifying whether duplicate results must be eliminated from the query result or whether they must be retained

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override

from	back to summary
public <X> SqmRoot<X> from(Class<X> entityClass) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Doc from jakarta.persistence.criteria.AbstractQuery.from. Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots. Parameters entityClass:Class<X> the entity class Returns:SqmRoot<X> query root corresponding to the given entity Annotations @Override

from

back to summary

public <X> SqmRoot<X> from(Class<X> entityClass)

Implements org.hibernate.query.criteria.JpaSelectCriteria.from.

Doc from jakarta.persistence.criteria.AbstractQuery.from.

Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots.

Parameters

entityClass:Class<X>: the entity class

Returns:SqmRoot<X>

query root corresponding to the given entity

Annotations

@Override

from	back to summary
public <X> SqmDerivedRoot<X> from(Subquery<X> subquery) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Doc from org.hibernate.query.criteria.JpaSelectCriteria.from. Create and add a query root corresponding to the given subquery, forming a cartesian product with any existing roots. Parameters subquery:Subquery<X> the subquery Returns:SqmDerivedRoot<X> query root corresponding to the given subquery Annotations @Override

from

back to summary

public <X> SqmDerivedRoot<X> from(Subquery<X> subquery)

Implements org.hibernate.query.criteria.JpaSelectCriteria.from.

Doc from org.hibernate.query.criteria.JpaSelectCriteria.from.

Create and add a query root corresponding to the given subquery, forming a cartesian product with any existing roots.

Parameters

subquery:Subquery<X>: the subquery

Returns:SqmDerivedRoot<X>

query root corresponding to the given subquery

Annotations

@Override

from	back to summary
public <X> JpaRoot<X> from(JpaCteCriteria<X> cte) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Doc from org.hibernate.query.criteria.JpaSelectCriteria.from. Create and add a query root corresponding to the given cte, forming a cartesian product with any existing roots. Parameters cte:JpaCteCriteria<X> the cte criteria Returns:JpaRoot<X> query root corresponding to the given cte

from

back to summary

public <X> JpaRoot<X> from(JpaCteCriteria<X> cte)

Implements org.hibernate.query.criteria.JpaSelectCriteria.from.

Doc from org.hibernate.query.criteria.JpaSelectCriteria.from.

Create and add a query root corresponding to the given cte, forming a cartesian product with any existing roots.

Parameters

cte:JpaCteCriteria<X>: the cte criteria

Returns:JpaRoot<X>

query root corresponding to the given cte

from	back to summary
public <X> SqmRoot<X> from(EntityType<X> entityType) Implements org.hibernate.query.criteria.JpaSelectCriteria.from. Doc from jakarta.persistence.criteria.AbstractQuery.from. Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots. Parameters entityType:EntityType<X> metamodel entity representing the entity of type X Returns:SqmRoot<X> query root corresponding to the given entity Annotations @Override

from

back to summary

public <X> SqmRoot<X> from(EntityType<X> entityType)

Implements org.hibernate.query.criteria.JpaSelectCriteria.from.

Doc from jakarta.persistence.criteria.AbstractQuery.from.

Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots.

Parameters

entityType:EntityType<X>: metamodel entity representing the entity of type X

Returns:SqmRoot<X>

query root corresponding to the given entity

Annotations

@Override

getCteCriteria	back to summary
public <X> JpaCteCriteria<X> getCteCriteria(String cteName) Implements org.hibernate.query.criteria.JpaCteContainer.getCteCriteria. Doc from org.hibernate.query.criteria.JpaCteContainer.getCteCriteria. Returns a CTE that is registered by the given name on this container, or any of its parents. Annotations @Override

getCteCriteria

back to summary

public <X> JpaCteCriteria<X> getCteCriteria(String cteName)

Implements org.hibernate.query.criteria.JpaCteContainer.getCteCriteria.

Doc from org.hibernate.query.criteria.JpaCteContainer.getCteCriteria.

Returns a CTE that is registered by the given name on this container, or any of its parents.

Annotations

@Override

getCteCriterias	back to summary
public Collection<? extends JpaCteCriteria<?>> getCteCriterias() Implements org.hibernate.query.criteria.JpaCteContainer.getCteCriterias. Doc from org.hibernate.query.criteria.JpaCteContainer.getCteCriterias. Returns the CTEs that are registered on this container. Annotations @Override

getCteCriterias

back to summary

public Collection<? extends JpaCteCriteria<?>> getCteCriterias()

Implements org.hibernate.query.criteria.JpaCteContainer.getCteCriterias.

Doc from org.hibernate.query.criteria.JpaCteContainer.getCteCriterias.

Returns the CTEs that are registered on this container.

Annotations

@Override

getCteStatement	back to summary
public SqmCteStatement<?> getCteStatement(String cteLabel) Implements org.hibernate.query.sqm.tree.cte.SqmCteContainer.getCteStatement. Annotations @Override

getCteStatement

back to summary

public SqmCteStatement<?> getCteStatement(String cteLabel)

Implements org.hibernate.query.sqm.tree.cte.SqmCteContainer.getCteStatement.

Annotations

@Override

getCteStatementMap	back to summary
pack-priv Map<String, SqmCteStatement<?>> getCteStatementMap()

getCteStatements	back to summary
public Collection<SqmCteStatement<?>> getCteStatements() Implements org.hibernate.query.sqm.tree.cte.SqmCteContainer.getCteStatements. Annotations @Override

getCteStatements

back to summary

public Collection<SqmCteStatement<?>> getCteStatements()

Implements org.hibernate.query.sqm.tree.cte.SqmCteContainer.getCteStatements.

Annotations

@Override

getGroupList	back to summary
public List<Expression<?>> getGroupList() Implements jakarta.persistence.criteria.AbstractQuery.getGroupList. Doc from jakarta.persistence.criteria.AbstractQuery.getGroupList. Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query. Returns:List<Expression<?>> the list of grouping expressions Annotations @Override @SuppressWarnings:unchecked

getGroupList

back to summary

public List<Expression<?>> getGroupList()

Implements jakarta.persistence.criteria.AbstractQuery.getGroupList.

Doc from jakarta.persistence.criteria.AbstractQuery.getGroupList.

Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query.

Returns:List<Expression<?>>

the list of grouping expressions

Annotations

@Override
@SuppressWarnings:unchecked

getGroupRestriction	back to summary
public SqmPredicate getGroupRestriction() Implements org.hibernate.query.criteria.JpaSelectCriteria.getGroupRestriction. Doc from jakarta.persistence.criteria.AbstractQuery.getGroupRestriction. Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified. Returns:SqmPredicate having clause predicate Annotations @Override

getGroupRestriction

back to summary

public SqmPredicate getGroupRestriction()

Implements org.hibernate.query.criteria.JpaSelectCriteria.getGroupRestriction.

Doc from jakarta.persistence.criteria.AbstractQuery.getGroupRestriction.

Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified.

Returns:SqmPredicate

having clause predicate

Annotations

@Override

getQueryPart back to summary

getQueryPart	back to summary
public SqmQueryPart<T> getQueryPart() Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.getQueryPart. Doc from org.hibernate.query.criteria.JpaSelectCriteria.getQueryPart. The query structure. See `JpaQueryStructure` for details Annotations @Override

public SqmQueryPart<T> getQueryPart()

Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.getQueryPart.

Doc from org.hibernate.query.criteria.JpaSelectCriteria.getQueryPart.

The query structure. See JpaQueryStructure for details

Annotations

@Override

getQuerySpec back to summary

getQuerySpec	back to summary
public SqmQuerySpec<T> getQuerySpec() Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.getQuerySpec. Doc from org.hibernate.query.criteria.JpaSelectCriteria.getQuerySpec. The query structure. See `JpaQueryStructure` for details Annotations @Override

public SqmQuerySpec<T> getQuerySpec()

Implements org.hibernate.query.sqm.tree.select.SqmSelectQuery.getQuerySpec.

Doc from org.hibernate.query.criteria.JpaSelectCriteria.getQuerySpec.

The query structure. See JpaQueryStructure for details

Annotations

@Override

getRestriction	back to summary
public SqmPredicate getRestriction() Implements org.hibernate.query.criteria.JpaCriteriaBase.getRestriction, org.hibernate.query.criteria.JpaSelectCriteria.getRestriction. Doc from jakarta.persistence.criteria.CommonAbstractCriteria.getRestriction. Return the predicate that corresponds to the where clause restriction(s), or null if no restrictions have been specified. Returns:SqmPredicate where clause predicate Annotations @Override

getRestriction

back to summary

public SqmPredicate getRestriction()

Implements org.hibernate.query.criteria.JpaCriteriaBase.getRestriction, org.hibernate.query.criteria.JpaSelectCriteria.getRestriction.

Doc from jakarta.persistence.criteria.CommonAbstractCriteria.getRestriction.

Return the predicate that corresponds to the where clause restriction(s), or null if no restrictions have been specified.

Returns:SqmPredicate

where clause predicate

Annotations

@Override

getResultSelection	back to summary
protected Selection<? extends T> getResultSelection(Selection<?>[] selections)

getResultType back to summary

getResultType	back to summary
public Class<T> getResultType() Implements jakarta.persistence.criteria.AbstractQuery.getResultType. Doc from jakarta.persistence.criteria.AbstractQuery.getResultType. Return the result type of the query or subquery. If a result type was specified as an argument to the `createQuery` or `subquery` method, that type will be returned. If the query was created using the `createTupleQuery` method, the result type is `Tuple`. Otherwise, the result type is `Object`. Returns:Class<T> result type Annotations @Override

public Class<T> getResultType()

Implements jakarta.persistence.criteria.AbstractQuery.getResultType.

Doc from jakarta.persistence.criteria.AbstractQuery.getResultType.

Return the result type of the query or subquery. If a result type was specified as an argument to the createQuery or subquery method, that type will be returned. If the query was created using the createTupleQuery method, the result type is Tuple. Otherwise, the result type is Object.

Returns:Class<T>

result type

Annotations

@Override

getRootList	back to summary
public List<Root<?>> getRootList()

getRoots back to summary

getRoots	back to summary
public Set<Root<?>> getRoots() Implements jakarta.persistence.criteria.AbstractQuery.getRoots. Doc from jakarta.persistence.criteria.AbstractQuery.getRoots. Return the query roots. These are the roots that have been defined for the `CriteriaQuery` or `Subquery` itself, including any subquery roots defined as a result of correlation. Returns empty set if no roots have been defined. Modifications to the set do not affect the query. Returns:Set<Root<?>> the set of query roots Annotations @Override @SuppressWarnings:unchecked

public Set<Root<?>> getRoots()

Implements jakarta.persistence.criteria.AbstractQuery.getRoots.

Doc from jakarta.persistence.criteria.AbstractQuery.getRoots.

Return the query roots. These are the roots that have been defined for the CriteriaQuery or Subquery itself, including any subquery roots defined as a result of correlation. Returns empty set if no roots have been defined. Modifications to the set do not affect the query.

Returns:Set<Root<?>>

the set of query roots

Annotations

@Override
@SuppressWarnings:unchecked

getSelection	back to summary
public JpaSelection<T> getSelection() Implements org.hibernate.query.criteria.JpaSelectCriteria.getSelection. Doc from jakarta.persistence.criteria.AbstractQuery.getSelection. Return the selection of the query, or null if no selection has been set. Returns:JpaSelection<T> selection item Annotations @Override

getSelection

back to summary

public JpaSelection<T> getSelection()

Implements org.hibernate.query.criteria.JpaSelectCriteria.getSelection.

Doc from jakarta.persistence.criteria.AbstractQuery.getSelection.

Return the selection of the query, or null if no selection has been set.

Returns:JpaSelection<T>

selection item

Annotations

@Override

groupBy	back to summary
public SqmSelectQuery<T> groupBy(Expression<?>... expressions) Implements org.hibernate.query.criteria.JpaSelectCriteria.groupBy. Doc from jakarta.persistence.criteria.AbstractQuery.groupBy. Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters expressions:Expression<?>[] zero or more grouping expressions Returns:SqmSelectQuery<T> the modified query Annotations @Override

groupBy

back to summary

public SqmSelectQuery<T> groupBy(Expression<?>... expressions)

Implements org.hibernate.query.criteria.JpaSelectCriteria.groupBy.

Doc from jakarta.persistence.criteria.AbstractQuery.groupBy.

Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed.

Parameters

expressions:Expression<?>[]: zero or more grouping expressions

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override

groupBy	back to summary
public SqmSelectQuery<T> groupBy(List<Expression<?>> grouping) Implements org.hibernate.query.criteria.JpaSelectCriteria.groupBy. Doc from jakarta.persistence.criteria.AbstractQuery.groupBy. Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters grouping:List<Expression<?>> list of zero or more grouping expressions Returns:SqmSelectQuery<T> the modified query Annotations @Override @SuppressWarnings:unchecked

groupBy

back to summary

public SqmSelectQuery<T> groupBy(List<Expression<?>> grouping)

Implements org.hibernate.query.criteria.JpaSelectCriteria.groupBy.

Doc from jakarta.persistence.criteria.AbstractQuery.groupBy.

Parameters

grouping:List<Expression<?>>: list of zero or more grouping expressions

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override
@SuppressWarnings:unchecked

having	back to summary
public SqmSelectQuery<T> having(Expression<Boolean> booleanExpression) Implements org.hibernate.query.criteria.JpaSelectCriteria.having. Doc from jakarta.persistence.criteria.AbstractQuery.having. Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any. Parameters booleanExpression:Expression<Boolean> a simple or compound boolean expression Returns:SqmSelectQuery<T> the modified query Annotations @Override

having

back to summary

public SqmSelectQuery<T> having(Expression<Boolean> booleanExpression)

Implements org.hibernate.query.criteria.JpaSelectCriteria.having.

Doc from jakarta.persistence.criteria.AbstractQuery.having.

Specify a restriction over the groups of the query. Replaces the previous having restriction(s), if any.

Parameters

booleanExpression:Expression<Boolean>: a simple or compound boolean expression

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override

having	back to summary
public SqmSelectQuery<T> having(Predicate... predicates) Implements org.hibernate.query.criteria.JpaSelectCriteria.having. Doc from jakarta.persistence.criteria.AbstractQuery.having. 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 are specified, any previously added restrictions are simply removed. Parameters predicates:Predicate[] zero or more restriction predicates Returns:SqmSelectQuery<T> the modified query Annotations @Override

having

back to summary

public SqmSelectQuery<T> having(Predicate... predicates)

Implements org.hibernate.query.criteria.JpaSelectCriteria.having.

Doc from jakarta.persistence.criteria.AbstractQuery.having.

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 are specified, any previously added restrictions are simply removed.

Parameters

predicates:Predicate[]: zero or more restriction predicates

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override

isDistinct	back to summary
public boolean isDistinct() Implements jakarta.persistence.criteria.AbstractQuery.isDistinct. Doc from jakarta.persistence.criteria.AbstractQuery.isDistinct. Return whether duplicate query results must be eliminated or retained. Returns:boolean boolean indicating whether duplicate query results must be eliminated Annotations @Override

isDistinct

back to summary

public boolean isDistinct()

Implements jakarta.persistence.criteria.AbstractQuery.isDistinct.

Doc from jakarta.persistence.criteria.AbstractQuery.isDistinct.

Return whether duplicate query results must be eliminated or retained.

Returns:boolean

boolean indicating whether duplicate query results must be eliminated

Annotations

@Override

setQueryPart	back to summary
public void setQueryPart(SqmQueryPart<T> sqmQueryPart)

setResultType	back to summary
protected void setResultType(Class<T> resultType)

validateComplianceFromSubQuery	back to summary
private void validateComplianceFromSubQuery()

validateCteName	back to summary
private String validateCteName(String name)

where	back to summary
public SqmSelectQuery<T> where(Expression<Boolean> restriction) Implements org.hibernate.query.criteria.JpaSelectCriteria.where. Doc from jakarta.persistence.criteria.AbstractQuery.where. Modify the query to restrict the query results according to the specified boolean expression. Replaces the previously added restriction(s), if any. Parameters restriction:Expression<Boolean> a simple or compound boolean expression Returns:SqmSelectQuery<T> the modified query Annotations @Override

where

back to summary

public SqmSelectQuery<T> where(Expression<Boolean> restriction)

Implements org.hibernate.query.criteria.JpaSelectCriteria.where.

Doc from jakarta.persistence.criteria.AbstractQuery.where.

Modify the query to restrict the query results according to the specified boolean expression. Replaces the previously added restriction(s), if any.

Parameters

restriction:Expression<Boolean>: a simple or compound boolean expression

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override

where	back to summary
public SqmSelectQuery<T> where(Predicate... restrictions) Implements org.hibernate.query.criteria.JpaSelectCriteria.where. Doc from jakarta.persistence.criteria.AbstractQuery.where. Modify the query to restrict the query results according to the conjunction of the specified restriction predicates. Replaces the previously added restriction(s), if any. If no restrictions are specified, any previously added restrictions are simply removed. Parameters restrictions:Predicate[] zero or more restriction predicates Returns:SqmSelectQuery<T> the modified query Annotations @Override

where

back to summary

public SqmSelectQuery<T> where(Predicate... restrictions)

Implements org.hibernate.query.criteria.JpaSelectCriteria.where.

Doc from jakarta.persistence.criteria.AbstractQuery.where.

Modify the query to restrict the query results according to the conjunction of the specified restriction predicates. Replaces the previously added restriction(s), if any. If no restrictions are specified, any previously added restrictions are simply removed.

Parameters

restrictions:Predicate[]: zero or more restriction predicates

Returns:SqmSelectQuery<T>

the modified query

Annotations

@Override

with back to summary

with	back to summary
public <X> JpaCteCriteria<X> with(AbstractQuery<X> criteria) Implements org.hibernate.query.criteria.JpaCteContainer.with. Doc from org.hibernate.query.criteria.JpaCteContainer.with. Registers the given `CriteriaQuery` and returns a `JpaCteCriteria`, which can be used for querying. Annotations @Override

public <X> JpaCteCriteria<X> with(AbstractQuery<X> criteria)

Implements org.hibernate.query.criteria.JpaCteContainer.with.

Doc from org.hibernate.query.criteria.JpaCteContainer.with.

Registers the given CriteriaQuery and returns a JpaCteCriteria, which can be used for querying.

Annotations

@Override

with back to summary

with	back to summary
public <X> JpaCteCriteria<X> with(String name, AbstractQuery<X> criteria) Implements org.hibernate.query.criteria.JpaCteContainer.with. Doc from org.hibernate.query.criteria.JpaCteContainer.with. Like `with(AbstractQuery)` but assigns an explicit CTE name. Annotations @Override

public <X> JpaCteCriteria<X> with(String name, AbstractQuery<X> criteria)

Implements org.hibernate.query.criteria.JpaCteContainer.with.

Doc from org.hibernate.query.criteria.JpaCteContainer.with.

Like with(AbstractQuery) but assigns an explicit CTE name.

Annotations

@Override

withInternal	back to summary
private <X> JpaCteCriteria<X> withInternal(String name, AbstractQuery<X> criteria)

withInternal	back to summary
private <X> JpaCteCriteria<X> withInternal(String name, AbstractQuery<X> baseCriteria, boolean unionDistinct, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer)

withRecursiveUnionAll back to summary

withRecursiveUnionAll	back to summary
public <X> JpaCteCriteria<X> withRecursiveUnionAll(AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer) Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll. Doc from org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll. Allows to register a recursive CTE. The base `CriteriaQuery` serves for the structure of the `JpaCteCriteria`, which is made available in the recursive criteria producer function, so that the recursive `CriteriaQuery` is able to refer to the CTE again. Annotations @Override

public <X> JpaCteCriteria<X> withRecursiveUnionAll(AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer)

Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll.

Doc from org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll.

Allows to register a recursive CTE. The base CriteriaQuery serves for the structure of the JpaCteCriteria, which is made available in the recursive criteria producer function, so that the recursive CriteriaQuery is able to refer to the CTE again.

Annotations

@Override

withRecursiveUnionAll back to summary

withRecursiveUnionAll	back to summary
public <X> JpaCteCriteria<X> withRecursiveUnionAll(String name, AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer) Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll. Doc from org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll. Like `withRecursiveUnionAll(AbstractQuery, Function)` but assigns an explicit CTE name. Annotations @Override

public <X> JpaCteCriteria<X> withRecursiveUnionAll(String name, AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer)

Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll.

Doc from org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionAll.

Like withRecursiveUnionAll(AbstractQuery, Function) but assigns an explicit CTE name.

Annotations

@Override

withRecursiveUnionDistinct back to summary

public <X> JpaCteCriteria<X> withRecursiveUnionDistinct(AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer)

Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionDistinct.

Doc from org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionDistinct.

Annotations

@Override

withRecursiveUnionDistinct back to summary

public <X> JpaCteCriteria<X> withRecursiveUnionDistinct(String name, AbstractQuery<X> baseCriteria, Function<JpaCteCriteria<X>, AbstractQuery<X>> recursiveCriteriaProducer)

Implements org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionDistinct.

Doc from org.hibernate.query.criteria.JpaCteContainer.withRecursiveUnionDistinct.

Like withRecursiveUnionDistinct(AbstractQuery, Function) but assigns an explicit CTE name.

Annotations

@Override

public abstract Class AbstractSqmSelectQuery<T>

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail