Leonel and Donatus - thank you for your responses.
Yes Leonel your suggested change works!
The one thing that is not working is that the headers for the Sum and Count
columns display as "count('dpspend'.'amount')" and
"SUM('dpspend'.'amount')" rather than the values that I specified in the
headers variable - "Records" & "Total amount"). The other headers work fine.
I can willingly supply a test app if that would be helpful.
On Wednesday, 8 November 2017 15:37:25 UTC, Leonel Câmara wrote:
>
> Can you test something for me:
>
> in your web2py folder in file gluon/sqlhtml.py in SQLTABLE can you
> replace
>
> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>
> with:
>
> tablemap = dict(((f.tablename, f.table) if isinstance(f, Field) else (f.
> _table._tablename, f._table) for f in fieldmap.values()))
>
> Restart web2py and check if this solved your problem.
>
> Otherwise you need to give me a test app because I don't really use
> SQLTABLE and this failing means there are more problems besides this
> evident one. If it works, then great and I'll submit a pull request with
> the fix.
>
--
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.
