cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frank Herrmann <frank.herrm...@modernizingmedicine.com>
Subject Re: Ordering by date on a timestamp field
Date Thu, 09 Jun 2016 13:27:29 GMT
Thanks everyone.

Andrus, is SQLSelect in Cayenne 3.1, or is it new in 4.0.

Thanks,

-Frank

On Thu, Jun 9, 2016 at 6:12 AM, Hugi Thordarson <hugi@karlmenn.is> wrote:

> 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.herrmann@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 <aboyle@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.herrmann@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.herrmann@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.herrmann@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.herrmann@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>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message