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
