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

Using having clause with EntityQuery

Xavier Boubés Newbie

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
    Xavier Boubés Newbie

    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