Hello Everybody!
I tried this way also:
sales = Sale.objects.extra(select={'
month':
'month(date_created)'}).filter(date_created__range=(init_date,ends_date)).values('month').aggregate(total_sales=Sum('total_value'))
but returned {}
Any ideias?
Cheers,
Rogério Carrasqueira
---
e-mail: rogerio.carrasque...@gmail.com
skype: rgcarrasqueira
MSN: rcarrasque...@hotmail.com
ICQ: 50525616
Tel.: (11) 7805-0074
Em 28 de outubro de 2010 11:41, Rogério Carrasqueira <
rogerio.carrasque...@gmail.com> escreveu:
> Hi Franklin!
>
> Thanks for you answer. Unfortunatelly I need to output my results on a JSON
> file. Do you have any other approach?
>
> Cheers,
>
>
> Rogério Carrasqueira
>
> ---
> e-mail: rogerio.carrasque...@gmail.com
> skype: rgcarrasqueira
> MSN: rcarrasque...@hotmail.com
> ICQ: 50525616
> Tel.: (11) 7805-0074
>
>
>
> 2010/10/28 Franklin Einspruch <franklin.einspr...@gmail.com>
>
> It may not be a complete answer, but you should know about {% regroup
>> %} just in case:
>>
>>
>> http://docs.djangoproject.com/en/dev/ref/templates/builtins/?from=olddocs#regroup
>>
>> - Franklin
>>
>> --
>> Art, writing, journal: http://einspruch.com
>> Comics: http://themoonfellonme.com
>>
>>
>>
>>
>> 2010/10/28 Rogério Carrasqueira <rogerio.carrasque...@gmail.com>:
>> > Hello!
>> >
>> > I'm having an issue to make complex queries in django. My problem is, I
>> have
>> > a model where I have the sales and I need to make a report showing the
>> sales
>> > amount per month, by the way I made this query:
>> >
>> > init_date = datetime.date(datetime.now()-timedelta(days=365))
>> > ends_date = datetime.date(datetime.now())
>> > sales =
>> >
>> Sale.objects.filter(date_created__range=(init_date,ends_date)).values(date_created__month).aggregate(total_sales=Sum('total_value'))
>> >
>> > At the first line I get the today's date past one year
>> > after this I got the today date
>> >
>> > at sales I'm trying to between a range get the sales amount grouped by
>> > month, but unfortunatelly I was unhappy on this, because this error
>> > appeared:
>> >
>> > global name 'date_created__month' is not defined
>> >
>> > At date_created is the field where I store the information about when
>> the
>> > sale was done., the __moth was a tentative to group by this by month.
>> >
>> > So, my question: how to do that thing without using a raw sql query and
>> not
>> > touching on database independence?
>> >
>> > Thanks so much!
>> >
>> > Rogério Carrasqueira
>> >
>> > ---
>> > e-mail: rogerio.carrasque...@gmail.com
>> > skype: rgcarrasqueira
>> > MSN: rcarrasque...@hotmail.com
>> > ICQ: 50525616
>> > Tel.: (11) 7805-0074
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> Groups
>> > "Django users" group.
>> > To post to this group, send email to django-us...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
>> .
>> > For more options, visit this group at
>> > http://groups.google.com/group/django-users?hl=en.
>> >
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To post to this group, send email to django-us...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/django-users?hl=en.
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
