Hi guys, I was wondering if i could create a sums column on an SQLFORM.grid
so that every search that's made produces a sums value, something like this:
*def payments(): grid = SQLFORM.grid(db.payments, args=[db.payments])
if grid.process().accepted: query=("#Search queries of the
SQLFORMgrid") amount =
db(query).select((db.payments.amount).sum().with_alias('total')) return
locals()*
Whats possible and whats not?
Regards;
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/e3dfb0fc-7b73-4564-bb14-f3d523832438n%40googlegroups.com.