May be VirtualFields http://www.web2py.com/book/default/chapter/06#Virtual-Fields <http://www.web2py.com/book/default/chapter/06#Virtual-Fields>
Bruno Rocha http://about.me/rochacbruno/bio 2011/1/14 Lorin Rivers <[email protected]> > Controller: > export_optimizer_records = > dbset(db.table.FreezeTime,db.table.StringID,db.table.Po_avg.sum(),groupby=..FreezeTime|..StringID).as_list() > > View: > var optimizerdata = {{response.write(json(export_optimizer_records), > escape=False)}}; > > > The JSON looks like this: > > [{ > "panel_1hrs": { > "FreezeTime": "2010-12-12 19:00:00", > "StringID": "S00000001" > }, > "_extra": { > "sum(panel_1hrs.Po_avg)": 519.912549612443 > } > }, > { > "panel_1hrs": { > "FreezeTime": "2010-12-12 19:00:00", > "StringID": "S00000002" > }, > "_extra": { > "sum(panel_1hrs.Po_avg)": 532.390706326218 > } > }] > > What I want is this: > > [{ > "FreezeTime": "2010-12-12 19:00:00", > "StringID": "S00000001", > "Po_avg_sum": 519.912549612443 > }, > { > "FreezeTime": "2010-12-12 19:00:00", > "StringID": "S00000002", > "Po_avg_sum": 532.390706326218 > }] > > What's the easiest way to get that? > -- > Lorin Rivers > Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> > <mailto:[email protected]> > 512/203.3198 (m) > > >
