*anthony solution in stackoverflow that i adapt to my table is *
return json.dumps([[r.product.name, r.subscription_amount] for r in rows] )
*reproduce*
"[[\"Dana Ekuitas\", 1.0], [\"Dana Likuid\", 2.0], [\"Dana Lancar\", 3.0]]"
*format that i want to have*
[['Dana Ekuitas', 1.0 ], ['Dana Likuid', 2.0 ], ['Dana Lancar', 3.0 ]]
*my models*
db.define_table('product',
Field('name'),
Field('fund_manager', 'reference fund_manager'),
Field('custodian_bank', 'reference custodian_bank'),
Field('currency', 'reference currency'),
Field('classification'),
Field('risk_n_return'),
Field('min_subscription', 'double'),
Field('min_next_subscription', 'double'),
Field('min_redemption', 'double'),
Field('subscription_fee', 'double'),
Field('redemption_fee_1', 'double'),
Field('redemption_fee_2', 'double'),
Field('duration', 'integer'),
format = lambda r: '%s - %s - %s' % (r.name, r.fund_manager.name,
r.classification) )
db.define_table('account',
Field('account_no'),
Field('investor', 'reference investor'),
Field('product', 'reference product'),
Field('fund_manager', 'reference fund_manager'),
Field('custodian_bank', 'reference custodian_bank'),
Field('currency', 'reference currency'),
Field('selling_agent', 'reference selling_agent'),
Field('unit', 'double'),
Field('nav_date', 'date'),
Field('nav_per_unit', 'double'),
Field('balance', 'double'),
Field('subscription_amount', 'double'),
Field('subscription_unit', 'double'),
Field('subscription_fee', 'double'),
Field('redemption_amount', 'double'),
Field('redemption_unit', 'double'),
Field('redemption_fee', 'double'),
Field('duration_plan', 'integer'),
Field('redemption_plan'),
Field('redemption_date_plan', 'date'),
Field('redemption_unit_plan', 'double'),
format = lambda r: '%s %s - %s - %s - %s - %s' % (r.investor.first_name,
r.investor.last_name, r.account_no, r.product.name, r.fund_manager.name,
r.selling_agent.name) )
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.
