Hi Frank, we solved this in one of our apps by creating a separate date-only column in the DB and mapping it to java.time.LocalTime in our model class. Then we just modified the setter for the dateTime value to also set the date-only value.
Cheers, - hugi // Hugi Thordarson // http://www.loftfar.is/ // s. 895-6688 > On 8. jún. 2016, at 20:49, Frank Herrmann > <frank.herrm...@modernizingmedicine.com> wrote: > > 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 <abo...@valsphere.com> 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 <frank.herrm...@modernizingmedicine.com> >> Sent: Wednesday, June 8, 2016 4:07:44 PM >> To: user@cayenne.apache.org >> 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: frank.herrm...@modmed.com >> >> >> >> [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: frank.herrm...@modmed.com > > > > [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>
