This is the result i get from a simple select like this: legacy_db(legacy_db.cursodado.gp_pro_id==course).select()
cursodado.gp_id cursodado.gp_pro_id cursodado.gp_historicdate cursodado.gp_curso_id 10003600042014-01-27 16:02:10None 10003600042014-01-27 17:18:31None 10003600042014-01-27 17:21:02None 10005250042014-01-27 16:02:10None 10005250042014-01-27 17:18:31None 10005250042014-01-27 17:21:02None Here i get the id of the person and the id of the course but I want only to show the first I once, that correspond to the max(cursodado.gp_historicdate) To see it like this: cursodado.gp_id cursodado.gp_pro_id cursodado.gp_historicdate cursodado.gp_curso_id 10003600042014-01-27 17:21:02None 10005250042014-01-27 17:21:02None tried this in the select but it gives a timeout: select(groupby=gp_id,having=max(historicdate field)) Thanks! -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
