Hi, Thank you for quick reply. I have used the patch to retrieve the rows I needed (for target query object).
Let's say I have retrieved list of 90 rows identified by id numbers [n,n+1,...n90]. My first idea was to combine the results of subsequent 'belongs' queries to build target query object. target_query_object = db.field.id.belongs(list_of_ids[n1:n30]) Magic_Operator db.field.id.belongs(list_of_ids[n31:n60]) Magic_Operator db.field.id.belongs(list_of_ids[n61:n90]) Unfortunately, I missed the magic operator to join sub queries (the 'and' and 'or' are not giving me what I want of course) . The problem is that query object (and subqueries in my case) does not return the final result I can use with available logical operators (if I understand it correctly), the query 'waits' to operate on database, it is some kind of prepared statements, this is why my trial failed. The real solution I am seeking is how to select not None rows from grid. I have taken round trip retrieving None rows (using =='' operator) and substracting it (using sets operations) from all rows. This is where i am so far (operators: " !='' " and " is not None " and " > None " are not supported in queries). Can you advise? Marcin Jaworski W dniu poniedziałek, 8 kwietnia 2013 04:34:57 UTC+2 użytkownik Christian Foster Howes napisał: > > speaking without reading the docs.....so i might be misguided..... > > assuming that you can setup a grid with a rows object, you can use that > patch. just & the rows together and magic will happen. > > the key no matter what is to setup multiple queries on GAE and & the > results together, or re-imagine the dataset so there is less than 30 items > in the belongs (which is sometimes impossible). > > good luck! > > cfh > > On Sunday, April 7, 2013 2:13:35 PM UTC-7, Marcin Jaworski wrote: >> >> Hi web2py users! >> >> My environment: GAE SDK 1.7.5, web2py version 2.0.9. >> >> I need a query object as an argument for grid. >> I've got a database rows (ids) as the potential base for query >> (list_of_ids) - unfortunately there are more than 30 of them so the >> construct with 'belongs' does not work on GAE: >> >> query = db.field.id.belongs(list_of_ids) # does not work on GAE >> >> There is a great solution to overcome the limit of 'belongs' on GAE: >> https://code.google.com/p/web2py/issues/detail?id=160 >> but it let me identify just rows, when the query object for grid is >> needed in my case. >> >> Can you advise? >> Marcin Jaworski >> >> >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
