On Monday, May 29, 2017 at 11:30:53 PM UTC-7, Brendan Barnwell wrote: > > When running queries that do joins, I often find the format of the result > somewhat cumbersome, with its nested structures representing the different > tables in the join. If I were writing the query in raw SQL, I would > probably use "AS" clauses to select just the columns that I want, with > simple "top-level" names. Something like > > Select Table1.foo as stuff, Table2.bar as blah from Table1, Table2 ... > > Is there a way to do this with Web2py? It would seem natural to specify > this inside the select call, something like > > db(db.Table1.foo=db.Table2.foo).select(db.Table1.foo.alias('foo'), > db.Table2.bar.alias('blah')) >
Any ideas on this? I continue to be especially frustrated at having to unpack the nested structure that occurs when I select using a join. I want to be able to easily "flatten" the structure into a single list of column names, rather than the existing structure where column names are nested inside table names. -- 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.