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
Post a Comment