Hello, I'm doing some exciting test using jqplot and handsontable with web2py. The approach is almost linear: controller with db(...).select(...).as_list() -> @service.json -> $.getJSON
But I've a problem using a count field, that produce a JSON output with a _extra field: Controller: @service.json def json_test: count=db.table.id.count() dati=db(table.afield==4).select(f_lunghezza,count,groupby(f_lunghezza)). as_list() return dict(data=dati) So if I open controller/json_test.json I get: {"data": [{"_extra": {"COUNT(*)": 2}, "table": {"f_lunghezza": 9.5}},...} qjplot has some problem with this kind of json format, so I had to use (client side) a js parser... ... $.each(data, function(index, value) { ticks.push(value['table']['f_lunghezza']); point.push(value['_extra']['COUNT(*)']); }); ... I'm looking for a (better) way to get, instead, the following json: {"data": [{"table": {"f_lunghezza": 9.5,"count":2}},...} There is a way? Thanks to all -- --- 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.