You could also do something like: query = (db.xxx.id==x.id) mainset = db(query) subquery = (db.xxx. <http://db.xxx.id/>primary_residence == True) subset = mainset(subquery) rows = subset.select()
take a look here <http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=virtual+fields#Query--Set--Rows> On Tue, Nov 3, 2015 at 3:14 PM, Massimiliano <mbelle...@gmail.com> wrote: > What about? > > foo = db((db.xxx.id==x.id) & (db.xxx.primary_residence == True)).select() > > On Tue, Nov 3, 2015 at 2:53 PM, Mark Billion <markbill...@gmail.com> > wrote: > >> This seems ugly: >> foo = db(db.xxx.id==x.id).select() >> for a in foo: >> if a.primary_residence == True: >> nine_b_count = 1 >> ...... >> Is there a way for me to select only the elements of foo that meet the >> secondary test. Something like foo.select(a.primary_residence == True) #I >> know this is wrong >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> 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 web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Massimiliano > -- Massimiliano -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.