Hibernate嵌套选择

Question

我希望从以下查询中只选择myEntity (e)结果

String query = "select e, to_char(message_date, 'yyyyMMdd') as dateOnly from myEntity e where e.lang = 'DE' and e.message.messageDate > sysdate-5 order by dateOnly desc, e.message.messageType asc"

因此，当我使用以下代码时

entityManager.createQuery(query).getResultList();

要获得List<myEntity>形式的结果，这意味着要执行以下查询

select e from (select e, to_char(message_date, 'yyyyMMdd') as dateOnly from myEntity e where e.lang = 'DE' and e.message.messageDate > sysdate-5 order by dateOnly desc, e.message.messageType asc)

Answer 1

我的问题是使用以下查询解决的

String query = "select e from myEntity e where e.lang = 'DE' and e.message.messageDate >     sysdate-5 order by to_char(message_date, 'yyyyMMdd') desc, e.message.messageType asc"