Hi everyone.
I'm trying to show how many logins every user has done in the last 7 days
in a view. I have the following query:
log_count=db.auth_event.id.count()
usrs =
db((db.auth_user.hidden==False)&(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)
And it works ok, but only show user that have logged in in the last 7 days.
I need to make this query to show 0 for user that have not logged in. I
have tried coalesce and distinct with no luck. And I have search the forum
and the docs and have found nothing.
Could you guys help me out a little.
Thank you.
--
---
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.
