[web2py] Re: Recursive select up to 2 levels

2011-11-17 Thread Cahya Dewanta
Thank you, Cliff. Now it's clear how to do recursive select to whatever level :)

[web2py] Re: Recursive select up to 2 levels

2011-11-17 Thread Cliff
query = ((db.owner.id==somevaluethatyousupply) & (db.retail.owner_id==db.owner.id) & (db.administer.retail_id==db.retail.id)) rows = db(query)select(db.administer.name) The first line in the query gets the owner row. The second line gets all the retails related to the owner. The

[web2py] Re: Recursive select up to 2 levels

2011-11-17 Thread Cahya Dewanta
Thank you, DenesL!

[web2py] Re: Recursive select up to 2 levels

2011-11-17 Thread DenesL
You have to use nested selects (see book chapter on DAL) as follows: retids = db(db.retail.owner_id==ownid)._select(db.retail.id) adms = db(db.administer.retail_id.belongs(ret)).select() On Nov 16, 11:31 pm, Cahya Dewanta wrote: > Hello. Here's how I define my models: > > db.define_table('owne