Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Ordering by date on a timestamp field
From: Hugi Thordarson <hugi@karlmenn.is>
In-Reply-To: <CAF1JiVQgqeNg27AXcqDS-TCfCy9-ED-OvdoFfhSLV9WUyEiDwA@mail.gmail.com>
Date: Thu, 9 Jun 2016 10:12:22 +0000
Content-Transfer-Encoding: quoted-printable
Message-Id: <068F24B1-D354-4075-A3B9-17905F0D6AF7@karlmenn.is>
References: <CAF1JiVT3bqELXez8QrD4V9AqFDOLb1EENtoLQ7KWrrkJgo8uog@mail.gmail.com> <BY2PR06MB213353D051410274A14AD2E3CB5E0@BY2PR06MB2133.namprd06.prod.outlook.com> <CAF1JiVQgqeNg27AXcqDS-TCfCy9-ED-OvdoFfhSLV9WUyEiDwA@mail.gmail.com>
To: user@cayenne.apache.org
archived-at: Thu, 09 Jun 2016 10:12:40 -0000

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=C3=BAn. 2016, at 20:49, Frank Herrmann =
<frank.herrmann@modernizingmedicine.com> wrote:
>=20
> 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.
>=20
> -Frank
>=20
> On Wed, Jun 8, 2016 at 4:42 PM, Adam Boyle <aboyle@valsphere.com> =
wrote:
>=20
>> 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.
>>=20
>>=20
>> -Adam
>>=20
>> ________________________________
>> 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
>>=20
>> Hello all,
>>=20
>> 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.
>>=20
>> 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.
>>=20
>> Thanks,
>>=20
>> -Frank
>>=20
>> --
>> FRANK HERRMANN
>> SOFTWARE ENGINEER
>>=20
>> T: 561-880-2998 x1563
>>=20
>> E: frank.herrmann@modmed.com
>>=20
>>=20
>>=20
>> [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>
>>=20
>=20
>=20
>=20
> --=20
> FRANK HERRMANN
> SOFTWARE ENGINEER
>=20
> T: 561-880-2998 x1563
>=20
> E: frank.herrmann@modmed.com
>=20
>=20
>=20
> [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>