About multiselect

manual

SELECT clause (JPQL / Criteria API)

Explains how to use the SELECT clause and projections in a JPA/JPQL query.... instances. CriteriaQuery's multiselect In the above examples,  CompoundSelection ... CriteriaQuery interface provides a shortcut method - multiselect multiselect(selections) CriteriaQuery's method ...

 
api-jpa

multiselect(selections)

Specify the selection items that are to be returned in the query result.(Method of javax.persistence.criteria.CriteriaQuery)

 
api-jpa

multiselect(selectionList)

Specify the selection items that are to be returned in the query result.(Method of javax.persistence.criteria.CriteriaQuery)

 
api-jpa

multiselect(selectionList)

Specify the selection items that are to be returned in the query result.(Method of javax.persistence.criteria.CriteriaQuery<T>)

 
api-jpa

javax.persistence.criteria.CriteriaQuery

The CriteriaQuery interface defines functionality that is specific to top-level queries.(Interface of JPA)

 
manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... ( Country. class ) ; q. multiselect multiselect(selections) CriteriaQuery's method Specify the ...

 
manual

JPA Query Structure (JPQL / Criteria)

Explains the structure of a JPQL query, which consists of 6 clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.... eliminated. See JavaDoc Reference Page... , multiselect multiselect(selections) CriteriaQuery's method Specify the ...

 
manual

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query.... ( Country. class ) ; q. multiselect multiselect(selections) CriteriaQuery's method Specify the ...

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... eliminated. See JavaDoc Reference Page... , multiselect multiselect(selections) CriteriaQuery's method Specify the ...

 
issue

Alias not used in ORDER BY

Hi, I am doing something simple like final Root<T> from = criteria.from(T.class) final Path<?> path = from.get("someStringProperty") final Expression<String> upperPath = builder.upper((Expression<String>) path); upperPath.alias("TEST"); criteria.multiselect(from, path); criteria.orderBy(builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause, something like ... alias ( "TEST" ) ; criteria. multiselect ( from, path ) ; criteria. orderBy ( ...