Hello,

sorry if that is obvious to more experienced Hibernate users:


i want to achieve ordering on the following query:

select day.items from
Day as day
where
(year(day.day) = ? and month(day.day) = ?)
order by day.day asc, item.hour asc
----------------


the day.items is a Map<Integer,Item>


Hibernate complains:

org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'item.hour'


how do I have to write the query correctly?


Many thanks!!