Your problem is about SQL. You need to use LEFT JOIN. This will help you: http://web2py.com/books/default/chapter/29/06#Left-outer-join
On Mon, Jul 1, 2013 at 9:49 PM, Francisco Betancourt <[email protected]> wrote: > 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. > > -- --- 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.
