Please help - I can't figure it out! My question is a bit detailed, but it's not about details - I am totally missing how to properly handle this kind of thing:
I have the following query: query = (db.ladore_order.created_on>=dt1) & (db.ladore_order.created_on<=dt2) rows = db(query).select(db.ladore_order.customer, db.ladore_order.created_on.max(), groupby=[db.ladore_order.customer], orderby=[~db.ladore_order.created_on.max()]) I have 3 issues here that I am looking to resolve: 1) It shows all the orders between the range of dates dt1 and dt2. However, the same customer may have ordered after dt2 also (so that created_on of the later order would be greater than dt2). I am looking ONLY for those customers/orders that ordered between dt1 and dt2 and haven't ordered since then. 2) Besides db.ladore_order.customer in the select, I also need db.ladore_order.id which corresponds to the latest order of the customer. I can run db.ladore_order.created_on.max(), but, obviously, I can't do the same for the id field. If I just keep db.ladore_order.id , without any aggregate function, in the select, it still works for sqlite, but it doesn't work for stricter db, like postgres. And it really shouldn't work with a field which is missing an aggregate function in the place of groupby. 3) If possible, I would also love to have the very same thing created with SQLFORM.grid() (I mean, I need both - rows with select, and also the 2nd way to do it with grid, if this is possible. Thank you for help!! -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/9fd6ac75-d39f-4bad-8fa3-46ea3e73b3dan%40googlegroups.com.
