I think that is the problem.
Data from rows.json()
Look at the data structure:
version 2.5.1
u'[{"SUM(qviewriepilogoprevisioni.motrici)": 0, "zona": "ABRUZZO",
"SUM(qviewriepilogoprevisioni.bilici)": 2,
"SUM(qviewriepilogoprevisioni.abbinati)": 0, "tratta": "ASCOLI (Ascoli
Piceno)"}, {"SUM(qviewriepilogoprevisioni.motrici)": 0, "zona": "ABRUZZO",
"SUM(qviewriepilogoprevisioni.bilici)": 3,
"SUM(qviewriepilogoprevisioni.abbinati)": 0, "tratta": "C. ABRUZZO
(Pescara)"}]'
version 2.9.5 Now aggregate fields are under "_extra"
[{"cooptratte": {"tratta": "ASCOLI (Ascoli Piceno)"}, "coopzone": {"zona":
"ABRUZZO"}, "_extra": {"SUM(qviewriepilogoprevisioni.bilici)": 1,
"SUM(qviewriepilogoprevisioni.motrici)": 0,
"SUM(qviewriepilogoprevisioni.abbinati)": 1}}]
Thank you
On Wed, Jun 4, 2014 at 10:47 AM, Niphlod <niph...@gmail.com> wrote:
> I don't know what to suggest unless you show some code.
>
>
> On Wednesday, June 4, 2014 10:23:29 AM UTC+2, Massimiliano wrote:
>
>> I think I explained the problem in the wrong way.
>>
>> Before, with the old version of web2py some procedures that make use of
>> datatable worked very well.
>> Today we miss some fields... aggregate fields.
>>
>> So I was looking for an hint to make the system work again with little
>> effort :D
>>
>> Thank you
>>
>>
>> On Tue, Jun 3, 2014 at 5:26 PM, Niphlod <nip...@gmail.com> wrote:
>>
>>> it's not a problem. we just changed the way a Rows class gets
>>> represented (printing resultsets with 1k rows was kynda lame ^_^)
>>> if you do
>>>
>>> print rows
>>>
>>> things "change", but
>>>
>>> for row in rows:
>>> print row
>>>
>>> doesn't change a bit.
>>>
>>>
>>> On Tuesday, June 3, 2014 12:53:08 PM UTC+2, Massimiliano wrote:
>>>>
>>>> Hello,
>>>>
>>>> I've an application in production with 2.5.1-stable+timestamp.2013.06
>>>> .06.15.39.19, and I would like to update at the newest
>>>> web2py 2.9.5-stable+timestamp.2014.03.16.02.35.39, but I could a
>>>> problem with aggregate fields.
>>>>
>>>> That is what's happen:
>>>>
>>>> If I print my Rows var I get:
>>>> print rows:
>>>>
>>>> zone.zona,tratte.tratta,SUM(qviewriepilogoprevisioni.bilici),SUM(
>>>> qviewriepilogoprevisioni.motrici),SUM(qviewriepilogoprevisioni.
>>>> abbinati)
>>>> ABRUZZO,ASCOLI (Ascoli Piceno),3,0,0
>>>> ABRUZZO,C. ABRUZZO (Pescara),2,0,0
>>>> ABRUZZO,S.BENEDETTO (),1,0,1
>>>>
>>>> BUT if I do something like that:
>>>>
>>>> TABLE(rows)
>>>>
>>>> I got ONLY the 2 fields zone.zona,tratte.tratta
>>>>
>>>> With the old web2py version this wasn't happen.
>>>> Where can I start to look at this problem?
>>>>
>>>> Thank you
>>>>
>>>> --
>>>> Massimiliano
>>>>
>>> --
>>> 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+un...@googlegroups.com.
>>>
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Massimiliano
>>
> --
> 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.
>
--
Massimiliano
--
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.
