1 Reply Latest reply on Apr 20, 2012 3:58 AM by xavybb

    Using having clause with EntityQuery

    xavybb

      HI,

       

      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?

        • 1. Re: Using having clause with EntityQuery
          xavybb

          Hello again,

          In recent days I've been looking for information about my problem and have not found any solution.

          At the risk of being wrong, and considering I have not received a reply, I assume that this functionality is not available in the class org.jboss.seam.framework.Query, so I'll try to add it myself.

          X. Boubés