[web2py] Re: Location of SQLFORM.grid pagination code for "count (*)" ?

2018-11-20 Thread Thomas Klopf
Hi Anthony, great thanks a lot for the info! I'll post a bug report as well. On Monday, November 19, 2018 at 4:05:30 PM UTC+1, Anthony wrote: > > The code used by the grid to generate the DAL query is at > https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L2351. > Notice you can

[web2py] Re: Location of SQLFORM.grid pagination code for "count (*)" ?

2018-11-19 Thread Anthony
The code used by the grid to generate the DAL query is at https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L2351. Notice you can do: SQLFORM.grid (..., cache_count=my_custom_count_function) where my_custom_count_function takes the DAL Set object used by the grid to generate the