Hi everyone.
I want to show the number of logins for every user in the last 7 days in a
view. I'm using this query:
log_count=db.auth_event.id.count()
usrs =
db((db.auth_event.user_id==db.auth_user.id)&(db.auth_event.time_stamp<datetime_start)&(db.auth_event.time_stamp>datetime_end)&(db.auth_event.description.contains('Logged-in'))).select(db.auth_user.ALL,log_count)
This is working, except that user that have not logged in in the last 7
days won't show up as a result in my query.
Could some one help correct my query? I have search through out the forum
and docs but couldn't find and answer. And when googling for an answer in
SQL it talks about COALESCE and also DISTINCT and tried both but had no
luck.
Thanks.
--
---
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/groups/opt_out.
