Re: [web2py] orderby=['alias'] - works in sqlite, but not in postgres

Thank you! On Tue, Jun 18, 2019, 1:19 AM Val K wrote: > Try [~db.cart_sharing.stats.sum()] > > -- > 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) > ---

[web2py] orderby=['alias'] - works in sqlite, but not in postgres

Try [~db.cart_sharing.stats.sum()] -- 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 Grou

[web2py] orderby=['alias'] - works in sqlite, but not in postgres

This works perfect in SQLite: rows = db(query).select(db.cart_sharing.created_by.with_alias('sharer'), db.cart_sharing.stats.count().with_alias('carts' ), db.cart_sharing.stats.sum().with_alias('shares'), groupby=d