You can get the result you want, if you add another field to your object that holds both dates. There's a new entry in the Google App Engine Cookbook that shows how: http://appengine-cookbook.appspot.com/recipe/how-to-query-by-date-range
Garrett Davis On Feb 4, 5:48 am, ryan <[email protected]> wrote: > On Feb 3, 7:59 am, Rick <[email protected]> wrote: > > > I'm confused. If this statement (GQL query is not allowed, because it > > uses inequality filters on two different properties in the same query) > > holds then how am I to do a Calendar type app and query the DataStore > > for all events that occur within a 30 day window? Isn't that > > something like: > > > Select * from Calendar where beginDate >= beginofDateRange and endDate > > <= endofDateRange > > as you've written it, this query is probably more expressive than you > need it to be. if you s/endDate/beginDate/, ie compare beginDate to > *both* of the range endpoints, you'll be able to run it. if you > absolutely need to query for events that occur entirely within the > endpoints, you could do the same query and post-process the results by > filtering out entities with endDate > endofDateRange in memory. if you > don't want to post-process, though, you're right, you can't do this > exact query entirely within the datastore. > > > How could I do that? How does Google Calendar do that? > > google calendar doesn't run on app engine, so it's not subject to the > same limitations as app engine. i'd also reiterate that while the app > engine datastore is based on bigtable, they're still very different > beasts. the datastore provides many additional (and different) > features, guarantees, and capabilities, including the query planner > and API. details > inhttp://sites.google.com/site/io/under-the-covers-of-the-google-app-en... > . > > > > > Thanks, > > Rick --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
