The grid is great for getting simple apps up quickly, but it's not your only option. It will take more time, but you can build your own grid, or even use jqgrid ( http://www.web2pyslices.com/slice/show/1400/jqgrid-and-web2py).
On Tuesday, October 8, 2013 4:31:55 AM UTC-7, Tim Richardson wrote: > > It seems that I can't use aggregate functions to create a column in a > SQLFORM.grid (because I can specify only a query, not a set) > Is this correct? > > I want to select patients with max visit date in a certain date range, > this I can do with 'having', but I also want to show that max visit date in > the grid. At the moment I do with with a helper via links (or could be a > virtual field). But this is slow and non-sortable. > > [What I use now: > > having_qry = (db_ps.visit.VisitDate.max() >= low_filter) & (db_ps.visit. > VisitDate.max() <= high_filter) > > lapsed_patients = db_ps()._select(db_ps.visit.PatientNo,groupby=db_ps. > visit.PatientNo, > having = having_qry > grid_query = (db_ps.cm_patient.patient_id.belongs(lapsed_patients)) > > -- 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/groups/opt_out.
