Hibernate Community • View topic - select from (select...) in criteria api

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

select from (select...) in criteria api

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Yamk

Post subject: select from (select...) in criteria api

Posted: Thu May 17, 2012 4:31 am

Newbie

Joined: Tue Dec 27, 2011 6:46 am
Posts: 3

I would very appreciate any help in translating query like this to criteria api:

Code:

select executor_id from (select executor_id, max(date_of_checking) as md from actions group by executor_id) as x where x.md < '2012-05-01'

I guess I have to create DetachedCriteria for internal select, but i have no idea how to attach it to main criteria.

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum