Hi Christian, Look at the IndirectQuery here (which uses an SQLTemplate):
http://cayenne.apache.org/doc12/customizing-queries.html I haven't tried using the EJBQLQuery yet, but I think that might support it, also. mrg On Tue, May 24, 2011 at 5:53 AM, Christian Grobmeier <grobme...@gmail.com> wrote: > Hey all, > > how do I do create "group by" or "sum" queries with Cayenne? > > Is an IndirectQuery/SQLTemplate the best way to do it? > > Cheers > Christian >