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)
