perhaps your question could be 'how can i do xyz given the 1000 result limit?'
basically can your task be done some other way? perhaps you can calculate something at write time. eg if its a sum or count you want. the limitations sometimes requires thinking outside the box! On 19/04/2009, Chris <chriss...@gmail.com> wrote: > > I have the model: > > class Record(db.Model): > date = db.DateProperty() > > Over 1000 Record instances may contain the same date value. The > instances are also not created in the order of their dates. > > I'm trying to query all instances whose date is within a given range. > I need to be able to query sets larger than the default max of 1000. > > I was thinking of doing something like: > > Record.all().filter('date >', startDate).filter('date <', endDate) > > But this would limit me at most to the first 1000 records. How would I > get the next 1000 records, maintaining the range query? I can't use > the last date value from the previous query as the startDate for the > next query, since there's no guarantee that the date value has > changed. For example, I could have 2000 instances with the date > 2008-1-1, so the first and second query sets have identical filter > parameters. > > Intuitively, I could accomplish this by simply filtering on the > previous key value (e.g. .filter('key >', lastKeyValue)). > Unfortunately, App Engine currently prohibits filtering with > inequality operators on more than one property. > > Am I correct in understanding that there's essentially no way to query > all instances within a specific date range, due to this limitation? > > This issue keeps coming up for me, and has been a huge deal-breaker in > a lot of potential projects I've been working on for App Engine. Any > advice on how I could work around it would be appreciated. > > > Chris > > > -- Barry - www.nearby.org.uk - www.geograph.org.uk - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---