*the code*
@service.json
def my_data():
query = (db.account.investor == 1)
rows = db(query).select(db.account.product.name,
db.account.subscription_amount, orderby = ~db.account.id).as_list()
return response.json(rows)
*reproduce*
[{"account": {"subscription_amount": 3.0}, "_extra": {"product": 3}},
{"account": {"subscription_amount": 2.0}, "_extra": {"product": 2}},
{"account": {"subscription_amount": 1.0}, "_extra": {"product": 1}}]
format is not expected
*format needed :*
[['Dana Ekuitas', 1.0 ], ['Dana Likuid', 2.0 ], ['Dana Lancar', 3.0 ]]
learned from anthony's solution in stackoverflow, he use return
json.dumps([[r.product.name, r.subscription_amount] for r in rows] )
but it return string only, when tested the chart result is not expected (a
lot of data looping (redundant))
how can i reproduce the format needed above?
thanks and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
