Hello im trying to add a line chart using this example but in the view i see the json output instead of a graph. Any help?
VIEW {{extend 'layout.html'}} <html> <script src="https://code.highcharts.com/stock/highstock.js"></script> <script src="https://code.highcharts.com/stock/modules/exporting.js"></script> <div id="chart"></div> <script type="application/javascript"> $.getJSON('http://127.0.0.1:8000/test/default/call/json/mystats', function (data) { // pie subscription $('#pie_subscription').highcharts({ series: [{ type: 'line', name: '{{=T('Subscription') }} ', data: [ {{for row_pie_subscription in rows:}} ['{{=T(row_pie_subscription.created_on) }}', {{=row_pie_subscription.qty}} ], {{pass}} ] }], }); }); </script> </html> CONTROLLER @service.json def mystats(): ownstats = db(db.water_flow_log.meter == auth.user.username).select(db.water_flow_log.ALL,orderby=~db.water_flow_log.date_made) rows = db(db.water_flow_log.meter == auth.user.username).select(db.water_flow_log.ALL,orderby=~db.water_flow_log.date_made) return response.json([[r.created_on, r.qty] for r in rows]) OUTPUT ON VIEW [["2017-02-24 14:32:20", 275.0], ["2017-02-24 10:52:50", 272.0], ["2017-02-24 10:32:57", 270.0]] On Friday, October 7, 2016 at 8:52:18 PM UTC+2, 黄祥 wrote: > > it's work as expected, thank you so much marlysson > e.g. > import gluon.contrib.simplejson > > def test(): > chosen = request.args(0) > query = (db.account.investor == chosen) > rows = db(query).select(orderby = ~db.account.id) > return gluon.contrib.simplejson.dumps([[r.product.name, > r.subscription_amount] for r in rows] ) > > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.