Dear Anthony,
Thank you so much.
Works perfectly and of Course Thanks for the explanation ...
Regards
Nicolas
Le dimanche 27 mai 2018 17:57:17 UTC+2, Anthony a écrit :
>
> query = db.auth_event.description.contains('connect')
>> query &= db.auth_event.time_stamp.max()
>> lastUserLogged = db(query).select(db.auth_event.user_id)
>>
>
> First, db.auth_event.time_stamp.max() simply produces the following SQL:
>
> MAX("auth_event"."time_stamp")
>
> It is not a query, just an expression.
>
> Second, your approach will not necessarily give you what you want, as
> there is no guarantee that the maximum timestamp value in the entire
> auth_event table happens to coincide with the most recent "connect" event
> (as opposed to some other type of event).
>
> Instead, a better approach is to (reverse) order by timestamp and limit
> the select to the first record:
>
> db(db.auth_event.description.contains('connect')).select(orderby=~db.
> auth_event.time_stamp,
> limitby=(0, 1))
>
> Anthony
>
--
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.
