The only problem is the join syntax with the DAL. The DAL expects you to pass the join alongside .select(). Thats a problem if you need to have multiple FULL OUTER JOINS for example. Say your looking for people who have an open invoice and have not paid within 90 days and they have an appointment scheduled and they have purchased ITEM 23457.
Unfortunately, you cannot do this in web2py since you would need to join on 5 or more tables in the above example. It would be nice to have a .join() construct in web2py, cause then we can do if request.vars.q_by_invoice_date: qry = qry.join(db.person.id == db.invoice.id_person)...... etc etc.. if request.vars.q_by_purchase_type: qry = qry.join(etc etc) -- Thadeus On Fri, Oct 22, 2010 at 1:56 PM, weheh <richard_gor...@verizon.net> wrote: > ry cool. Didn't know that. Is it in the doc? Makes incrementally > refining a search much ea >
