Re: [web2py] Grid query

2015-09-01 Thread Johann Spies
On 31 August 2015 at 15:17, Manuele Pesenti wrote: > Il 31/08/15 09:54, Manuele Pesenti ha scritto: > > to brutally by-pass the exception you can try something like... > > > > papers = db.wos_papers_by_dt.count.sum() > > setitem(papers, "tablename", "wos_papers_by_dt") > I apologize... I mean set

[web2py] Grid query

2015-08-27 Thread Johann Spies
In SQL I can do select doctype, sum(count) number from wos.za_publications where pubyear > 1979 group by doctype; In the web2py shell I can do: db.define_table('wos_papers_by_dt', Field('pubyear', 'integer'), Field('doctype'), Field('co