Views in mysql do not take advantage of indexes. We would like to avoid views and would prefer a Cayenne solution. Also, having a view with a formula is not very efficient, especially when dealing with hundreds of thousands of records.
-Frank On Wed, Jun 8, 2016 at 4:42 PM, Adam Boyle <[email protected]> wrote: > I can't speak to what Cayenne is able to do solely when using an > ObjectQuery, but from a database perspective it sounds like you want to be > using a view that provides the date-only version of your datetime column. > Then you could query it just like a table and do your sort on the date-only > column. You can probably use the Query object type in your project model to > achieve this if you aren't keen on adding SQL objects to your model outside > of Cayenne Modeler. > > > -Adam > > ________________________________ > From: Frank Herrmann <[email protected]> > Sent: Wednesday, June 8, 2016 4:07:44 PM > To: [email protected] > Subject: Ordering by date on a timestamp field > > Hello all, > > Is there a way in Cayenne, when adding an ordering to a query, to order by > only the date portion of a timestamp (including time) field? Basically, the > timestamp includes hour, minutes, seconds, etc. I only want to sort on the > date portion (month, day, year), or any other such criteria. > > The reason for this is, if we include other fields to sort by, we would > want the second sort field to group on the date, not the full timestamp. > > Thanks, > > -Frank > > -- > FRANK HERRMANN > SOFTWARE ENGINEER > > T: 561-880-2998 x1563 > > E: [email protected] > > > > [image: [ Modernizing Medicine ]] <http://www.modmed.com/> > [image: [ Facebook ]] <http://www.facebook.com/modernizingmedicine> > [image: > [ LinkedIn ]] <http://www.linkedin.com/company/modernizing-medicine/> > [image: > [ YouTube ]] <http://www.youtube.com/user/modernizingmedicine> [image: [ > Twitter ]] <https://twitter.com/modmed_EMA> [image: [ Blog ]] > <http://www.modmed.com/BlogBeyondEMR> [image: [ Instagram ]] > <http://instagram.com/modernizing_medicine> > -- FRANK HERRMANN SOFTWARE ENGINEER T: 561-880-2998 x1563 E: [email protected] [image: [ Modernizing Medicine ]] <http://www.modmed.com/> [image: [ Facebook ]] <http://www.facebook.com/modernizingmedicine> [image: [ LinkedIn ]] <http://www.linkedin.com/company/modernizing-medicine/> [image: [ YouTube ]] <http://www.youtube.com/user/modernizingmedicine> [image: [ Twitter ]] <https://twitter.com/modmed_EMA> [image: [ Blog ]] <http://www.modmed.com/BlogBeyondEMR> [image: [ Instagram ]] <http://instagram.com/modernizing_medicine>
