What string returned by : [[r.product.name, r.subscription_amount] for r in
rows] ?
Em sexta-feira, 7 de outubro de 2016 10:24:25 UTC-3, Marlysson Silva
escreveu:
>
> How are your database modeling..
> You are retrieving r.product.name but don't are in this row returned.. :/
> .
>
> Em sexta-feira, 7 de outubro de 2016 10:16:17 UTC-3, 黄祥 escreveu:
>>
>> *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.
