Re: Creating a GROUP BY query

From: Dorian (crapufis..mail.com)
Date: Sun Feb 18 2007 - 07:02:33 EST

  • Next message: Andrus Adamchik: "Re: Creating a GROUP BY query"

    Thanks for the answer!

    I would have another question... There is the data map xml file
    (*.map.xml) and this file contains also the custom queries I define...
    There is any way I can separate these custom queries (put them in
    another xml file) from the main data map file? I am asking because every
    time I regenerate the xml with the Cayenne Modeler, those queries are
    deleted. So every time I have to save them somewhere else and paste them
    in the new generated xml file.

    Thanks!

    Dorian

    Andrus Adamchik wrote:
    > Hi Dorian,
    >
    > As is the case with most ORM technologies, there is an "object query
    > syntax" and "db query syntax". Cayenne supports GROUP BY in the later
    > case via SQLTemplate. The result of course can be mapped to objects:
    >
    > http://cayenne.apache.org/doc/sqltemplate-query.html
    > http://cayenne.apache.org/doc/scripting-sqltemplate.html
    >
    > Andrus
    >
    > On Feb 17, 2007, at 5:35 PM, Dorian wrote:
    >> Hello!
    >>
    >> There is any way I can build a query with a GROUP BY clause?
    >>
    >>
    >> Thanks!
    >>
    >> Dorian
    >
    >

    This archive was generated by hypermail 2.0.0 : Sun Feb 18 2007 - 07:03:20 EST