Hello,
Is it possible to show the results from a SELECT (made with SQLite using
db.executesql) in a grid?
I have this
result = db.executesql(
"SELECT auth_user.id, auth_user.username, "
"auth_user.canceled_on, "
"auth_user.canceled_by, "
"SUM(auth_group.role = 'Operador') operador, "
"SUM(auth_group.role = 'Verificador') verificador, "
"SUM(auth_group.role = 'Supervisor') supervisor "
"FROM auth_user "
"LEFT JOIN auth_membership ON auth_user.id =
auth_membership.user_id "
"LEFT JOIN auth_group ON auth_group.id =
auth_membership.group_id "
"GROUP BY username ORDER BY username"
)
that returns a list of tuples, and would like to show it using the grid.
Is it possible?
Thanks,
JM
--
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].
For more options, visit https://groups.google.com/d/optout.
