If you read the first comment for that cookbook recipe, you see that it says:
"this recipe only works in the development server, this is a known issue" And that's from August 2009. Looks like this has been a known issue/bug since Oct 2008. They are working on making multiple inequality filters do-able (See NextGen IO talk): http://www.youtube.com/watch?v=ofhEyDBpngM#t=3m17s <http://www.youtube.com/watch?v=ofhEyDBpngM#t=3m17s>If you can't wait for the next generation queries, you could create some sort of hash function that takes the two properties you are doing the inequality filters on and creates a quasi unique hash value.. as long as you didn't have too many entities per hash value.. you could just query for the hash value then literally filter the inequalities in memory. On Sun, Oct 31, 2010 at 1:31 PM, johnterran <[email protected]> wrote: > This works in the development environment... > Basically, since we can't use inequality filter on more than 1 > property, so I used a list to check for range. > I followed the work around for range query from > http://appengine-cookbook.appspot.com/recipe/how-to-query-by-date-range > > If this doesn't work in production, how do I do a range query on > BigTable (use 2 inequality filters)? > > Thanks > John > > On Oct 31, 8:56 am, djidjadji <[email protected]> wrote: > > Both your inequality long values are the same > > timeRange > 1279593000 > > timeRange <= 1279593000 > > > > No timeRange value will ever match these two criteria > > > > 2010/10/31 johnterran <[email protected]>: > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > I am using this GQL range query and it works for me in the > > > development. > > > But once i deployed it to production, the query is not working, even > > > from the admin console. > > > And i can see the data, and it is within range.. > > > ie. > > > SELECT * from Event WHERE timeRange > 1279593000 AND timeRange <= > 1279593000 > > > > > class Event(db.Model): > > > name = db.StringProperty(required=True) > > > timeRange = db.ListProperty(long) > > > > > one sample data > > > Event.name Test > > > Event.timeRange [1279591200L, 1279594800L] > > > > > Why does this work in development but not in production? > > > I am running 1.3.7 in development due to datastore error in 1.3.8 on > > > win7 > > > > > thanks > > > John > > > > > -- > > > 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]<google-appengine%[email protected]> > . > > > For more options, visit this group athttp:// > groups.google.com/group/google-appengine?hl=en. > > -- > 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]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- 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.
