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?
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.