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 <doug...@gmail.com> 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 yyyy-mm-dd hh:mm:ss format.
>
> To select future events I started with the following code:
> SimpleDateFormat formatter;
> formatter = new SimpleDateFormat("yyyy-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.
