Re: group by and others

Thanks - I will stick with SQLTemplate/IndirectQuery then Cheers Christian On Tue, May 24, 2011 at 3:06 PM, Andrus Adamchik wrote: > EJBQLQuery supports those. > > On May 24, 2011, at 5:53 AM, Christian Grobmeier wrote: > >> Hey all, >> >> how do I do create "group by" or "sum" queries with Caye

Re: group by and others

EJBQLQuery supports those. On May 24, 2011, at 5:53 AM, Christian Grobmeier 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 >

Re: group by and others

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 wrote: > Hey all, > >

group by and others

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