web2py does not allow selecting only part of a JSON field. Sorry.
On Monday, 21 July 2014 08:51:59 UTC-5, Nicola Barbieri wrote:
>
>
> Hi everyone,
>
> I'm a web2py newbie and I'm having some hard time with the following
> simple task:
>
> I would like to show in a page all the records stored in the following
> MongoDB document (called requests):
>
> {
> "request": {
> "slice": [
> {
> "origin": "SFO",
> "destination": "MIA",
> "date": "2014-08-21"
> }
> ]
> }
> }
>
> My approach would be define a table with a json field and then parse it:
>
> *db.py:*
>
> db.define_table('requests',
> Field
> <https://nicolabarbieri.pythonanywhere.com/examples/global/vars/Field>('request','json'))
>
>
> *default.py:*
>
> def all_records():
> grid = SQLFORM.grid(db.requests,
> fields=[db.requests.request.slice[0].origin,db.requests.request.slice[0].destination,db.requests.request.slice[0].date)
> return locals()
>
>
> *all_records.html:*
>
> {{extend 'layout.html'}}
> {{=BEAUTIFY(response._vars)}}
>
>
> Though, I get this error:
> <type 'exceptions.AttributeError'> 'Field' object has no attribute 'slice'
>
> so I guess I'm parsing the JSON file in the wrong way.
>
>
> Any help is more than welcome,
>
> thanks
>
--
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.
