cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Ordering by date on a timestamp field
Date Thu, 09 Jun 2016 13:31:59 GMT
Ah sorry, that's 4.0. SQLTemplate is a less convenient (but fully functional) analog in 3.1

> On Jun 9, 2016, at 4:27 PM, Frank Herrmann <frank.herrmann@modernizingmedicine.com>
wrote:
> 
> 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
View raw message