Thanks for the prompt answer, Massimo.
Any suggestion on how I could approach my problem?
My goal would basically just query and show the records present in the
MongoDB document shown in the post.
Thanks,
Nicola
On Tuesday, July 22, 2014 8:37:48 AM UTC+2, Massimo Di Pierro wrote:
>
> 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.
