[google-appengine] Inequality Filters on a date and a number

2011-02-01 Thread Prashanth
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

Re: [google-appengine] Inequality Filters on a date and a number

2011-02-01 Thread Wim den Ouden
with the help of the cursor (all items, while loop) select on more than x_items, within the loop check if after some_input_date, append for example to python list or javascript array, when the loop is ready show the list. gr wim 2011/2/1 Prashanth prashanth.b...@gmail.com: Hi, Am trying to

Re: [google-appengine] Inequality Filters on a date and a number

2011-02-01 Thread Jeff Schwartz
This would require 2 inequality filters so no luck. On Tue, Feb 1, 2011 at 7:17 AM, Prashanth prashanth.b...@gmail.com 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

Re: [google-appengine] Inequality Filters on a date and a number

2011-02-01 Thread Jeff Schwartz
If the amount of data is merely trivial then this would work but anything more than merely trivial and the solution would have to include the use of tasks. On Tue, Feb 1, 2011 at 12:18 PM, Wim den Ouden wdenou...@gmail.com wrote: with the help of the cursor (all items, while loop) select on

Re: [google-appengine] Inequality Filters on a date and a number

2011-02-01 Thread Wim den Ouden
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

Re: [google-appengine] Inequality Filters on a date and a number

2011-02-01 Thread Jeff Schwartz
If you intend to make multiple calls passing the cursor back and forth between client and server then that would work but if you intend to do it all in one request then I think the poster of the original question would need to define how much data they were talking about which brings me back to