no, no, first the query on is item_names and more than x_items, then a loop on the result from this query (for items in resultquery:) if some_input_date > date: append to list when ready show list
you can play with fetch(..) to get optimum speed and cpu usage. ofcourse not a top solution, but it works till?? gr wim 2011/2/1 Jeff Schwartz <[email protected]>: > This would require 2 inequality filters so no luck. > > On Tue, Feb 1, 2011 at 7:17 AM, Prashanth <[email protected]> wrote: >> >> Hi, >> >> Am trying to query my Google App Engine datastore [Python], which has >> a item_name, manufacturing_date and number_of_items_shipped. >> The scenario: >> Get all the item_names which has been shipped more than x_items [user >> input] and manufactured after some_input_date [user input]. >> Basically, kind of inventory check. >> >> But due to restrictions on queries in GAE, am not able to do this. >> >> http://code.google.com/appengine/docs/python/datastore/queries.html#Restrictions_on_Queries >> >> I tried searching on the internet for this issue. But, no luck till >> now. Did you come across this issue, if so, were you able to resolve >> this? Please let me know. >> >> Also in Google I/O 2010, "Next Gen Queries" [http://www.youtube.com/ >> watch?v=ofhEyDBpngM#t=3m17s], Alfred Fuller mentioned that they are >> going to remove this restriction soon. Its been more than 8 months, >> but this restriction is in place even now. Makes life very difficult. >> >> Appreciate if anyone can post an answer if they were able to >> circumvent this restriciton. >> Thanks a lot. >> >> Regards, >> Prashanth. >> >> -- >> 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. >> > > > > -- > Jeff Schwartz > > -- > 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. > -- gr Wim den Ouden Custom applications, https://e-comm.appspot.com/ Free open source E-commerce/E-bookkeeping/E-business framework (web) apps, http://code.google.com/p/relat/ Gae developer tips, http://code.google.com/p/relat/wiki/gaetips -- 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.
