[web2py] Output of sum(), simplifying the JSON

[Lorin Rivers]

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:lriv...@mosasaur.com>
512/203.3198 (m)