7

In JPQL it is possible to ask for a subset of an entity using a constructor expression such as 

SELECT NEW example.EmployeeDetails(e.name, e.salary, e.department.name) FROM Employee e

which returns a list of objects of type EmployeeDetails

or using a projection select such as 

SELECT e.name, e.salary FROM Employee e

which returns an Object[] result where result[0] is e.name and result[1] is e.salary

is there a way to get JPA to return a Map which contains a subset of the entity for example is there a JPQL query that can return List<Map<String,Object>> result such that result.get(0).get("e.name") return e.name and result.get(0).get('e.salary') return e.salary

If JPQL can't do it does can HQL do it?

Frank Orellana
  • 1,690
  • 1
  • 21
  • 27
ams
  • 56,310
  • 64
  • 182
  • 269

1 Answers1

7

JPA provides limited amount of return types for compound selection: array, tuple and construct, while Hibernate provides much more return types for select clause, which includes Map.

SELECT NEW map(e.name, e.salary, e.department.name) FROM Employee e

This HQL query returns a Map from aliases to selected values.

JMelnik
  • 6,326
  • 2
  • 25
  • 41