I suggest you open a ticket about this and we could create an API to allow
it. Yet this is very specific of mongodb and the grid is not really setup
for this.
On Tuesday, 22 July 2014 10:47:28 UTC-5, Nicola Barbieri wrote:
>
> 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.
