Hi Hugi, Perhaps this can help you:
https://github.com/mrg/cbe/tree/master/FetchingObjects/Aggregates/src/main/java/cbe/fetching/utilities AggregateUtils uses AggregateTranslator to construct the SQL for a query (getting the SQL from Cayenne) and then manipulates it to run a COUNT(*) or SUM(...) type function based upon your original SelectQuery. Especially look at AggregateTranslator.createSqlString(). The example code using it might also help you: https://github.com/mrg/cbe/blob/master/FetchingObjects/Aggregates/src/main/java/cbe/fetching/Aggregates.java mrg On Tue, May 19, 2015 at 11:21 AM, Hugi Thordarson <h...@karlmenn.is> wrote: > Hi all. > > I’m creating a little utility method to emulate functionality from EOF, > i.e. to allow me to fetch distinct values for specified columns. This is > what I have so far: > > https://gist.github.com/hugith/05de4ad2f3d6f2cdc16a < > https://gist.github.com/hugith/05de4ad2f3d6f2cdc16a> > > However, I would like to be able to provide an expression to the query. > Does Cayenne have something to generate the SQL from an expression for me? > > Am I perhaps going totally wrong about this? > > Cheers, > - hugi
