Hibernate criteria with subquery in join -


is there way use criteria api sub query in join clause. have sql

select ud.email email,ul.last_login last_login, ul.login_count login_count, fb_count, m_count user_details ud left outer join user_logins userlogins1_ on ud.user_id=ul.user_id left outer join  (select count(feedback_id) fb_count,user_id user_feedback group user_id) uf on ud.user_id=uf.user_id  left outer join (select count(mapid) m_count,user_id maps group user_id) m  on ud.user_id=m.user_id order ud.email asc 

i saw criteria not support subquery in join support in select or clause. true?

i not finding way form above rewrite other way. please help/suggest me how proceed

simple answer is: can't. problem doing hibernate not know how map resultmof join since didn't created it.


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -