1 Reply Latest reply: Apr 20, 2012 3:58 AM by Xavier Boubés RSS

    Using having clause with EntityQuery

    Xavier Boubés Newbie



      In my seam 2.2 project I need to do this query:


      select avg( rt.value ) as avg, it  from Rate rt, Item it where it=rt.item group by it having avg( rt.value ) > 7;


      Although EntityQuery allow the use of "group by" I don't see any way to use the having clause.


      Is there any way to use a having clause with EntityQuery?