I realize grid is complicated enough as it is. But I would love this:
def grid(
query,
....
tbody=None,
...)
...
if tbody:
# call it if it's a function
# Insert if not
else:
# build rows as usual
...
)
On Tuesday, October 8, 2013 7:31:55 AM UTC-4, 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.
