I tried using different values too.. it looks like production app engine disabled multiple inequality filters even for single property. it does sound a lot like 798. I guess it is a know issue then. I wish this was disabled in development server too.
Next gen queries from youtube is what i want..I guess i didn't attend that session at I/O I'll filter the inequalities in memory Thanks guys. On Oct 31, 12:10 pm, Eli Jones <[email protected]> wrote: > 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%2Bunsubscrib > > [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%2Bunsubscrib > > [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.
