[appengine-java] Re: Filtering by Date using the Datastore Low Level API
The filter will just do string comparison (how should it know that you
are comparing dates??)
To get proper sorting/filtering just store the date as time in millis
and it will work.
Cheers,
Daniel
On 27 Nov., 04:25, Doug wrote:
> Good Evening Everyone,
>
> I am working on creating an event calendar type of page and am having
> trouble using the low level API and applying a filter to select events
> that occur in the future. The data that I am selecting has a property
> of "display_until" that holds a date in -mm-dd hh:mm:ss format.
>
> To select future events I started with the following code:
> SimpleDateFormat formatter;
> formatter = new SimpleDateFormat("-mm-dd hh:mm:ss");
> Date date = new Date();
> String query_date = formatter.format(date);
>
> query.addSort("display_until", Query.SortDirection.ASCENDING);
> query.addFilter("display_until",
> com.google.appengine.api.datastore.Query.FilterOperator.GREATER_THAN,
> query_date);
>
> When I ran this code it did select future events, but not all of
> them. Currently I have some 2009 and some 2010 events. It selected
> the 2010 events, but not the December 2009 events.
>
> Anyone have any suggestions for how I can select all of the future
> events?
>
> Thanks,
> Doug
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] Re: Filtering by Date using the Datastore Low Level API
I'm storing java.util.Date instances and filters work flawlessly. -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] Re: Filtering by Date using the Datastore Low Level API
Hi,
Though it might be unrelated.
I think that Date and Time Patterns of SimpleDateFormat is [MM] Month
in year [mm] Minute in hour.
thanks.
On 11月27日, 午後7:22, dflorey wrote:
> The filter will just do string comparison (how should it know that you
> are comparing dates??)
> To get proper sorting/filtering just store the date as time in millis
> and it will work.
>
> Cheers,
> Daniel
>
> On 27 Nov., 04:25, Doug wrote:
>
> > Good Evening Everyone,
>
> > I am working on creating an event calendar type of page and am having
> > trouble using the low level API and applying a filter to select events
> > that occur in the future. The data that I am selecting has a property
> > of "display_until" that holds a date in -mm-dd hh:mm:ss format.
>
> > To select future events I started with the following code:
> > SimpleDateFormat formatter;
> > formatter = new SimpleDateFormat("-mm-dd hh:mm:ss");
> > Date date = new Date();
> > String query_date = formatter.format(date);
>
> > query.addSort("display_until",
> > Query.SortDirection.ASCENDING);
> > query.addFilter("display_until",
> > com.google.appengine.api.datastore.Query.FilterOperator.GREATER_THAN,
> > query_date);
>
> > When I ran this code it did select future events, but not all of
> > them. Currently I have some 2009 and some 2010 events. It selected
> > the 2010 events, but not the December 2009 events.
>
> > Anyone have any suggestions for how I can select all of the future
> > events?
>
> > Thanks,
> > Doug
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] Re: Filtering by Date using the Datastore Low Level API
Correcting the SimpleDateFormat solved the problem. Thank you for
catching that!
Doug
On Nov 27, 5:26 am, m seleron wrote:
> Hi,
>
> Though it might be unrelated.
> I think that Date and Time Patterns of SimpleDateFormat is [MM] Month
> in year [mm] Minute in hour.
>
> thanks.
>
> On 11月27日, 午後7:22, dflorey wrote:
>
>
>
> > The filter will just do string comparison (how should it know that you
> > are comparing dates??)
> > To get proper sorting/filtering just store the date as time in millis
> > and it will work.
>
> > Cheers,
> > Daniel
>
> > On 27 Nov., 04:25, Doug wrote:
>
> > > Good Evening Everyone,
>
> > > I am working on creating an event calendar type of page and am having
> > > trouble using the low level API and applying a filter to select events
> > > that occur in the future. The data that I am selecting has a property
> > > of "display_until" that holds a date in -mm-dd hh:mm:ss format.
>
> > > To select future events I started with the following code:
> > > SimpleDateFormat formatter;
> > > formatter = new SimpleDateFormat("-mm-dd hh:mm:ss");
> > > Date date = new Date();
> > > String query_date = formatter.format(date);
>
> > > query.addSort("display_until",
> > > Query.SortDirection.ASCENDING);
> > > query.addFilter("display_until",
> > > com.google.appengine.api.datastore.Query.FilterOperator.GREATER_THAN,
> > > query_date);
>
> > > When I ran this code it did select future events, but not all of
> > > them. Currently I have some 2009 and some 2010 events. It selected
> > > the 2010 events, but not the December 2009 events.
>
> > > Anyone have any suggestions for how I can select all of the future
> > > events?
>
> > > Thanks,
> > > Doug
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
