Sunday, December 1, 2019

Re: Groups and summarys in template

Hi Man,
Plz try:
desired_value = Account.object.aggregate( subtotal = sum('Value', filter = Q(Date = date.todat())))




On Mon, Dec 2, 2019, 07:14 Elias Coutinho <coutinho.elias@gmail.com> wrote:
Well, the result I expect is a list with subtotals similar to the figure below:



Can you do it without javascript?

Em sáb., 30 de nov. de 2019 às 03:36, Dvenum <dvenum.at@gmail.com> escreveu:
Not sure I understand, what you doing, but you may use F() expression to compare fields in the query:
https://docs.djangoproject.com/en/2.2/ref/models/expressions/#f-expressions

On Sat, Nov 30, 2019 at 2:36 AM Elias Coutinho <coutinho.elias@gmail.com> wrote:
Good afternoon people!

I have the following querysets:

     accounts = Account.objects.filter (person__is_representative = False) .order_by ('due date')
     groups
= Account.objects.values ('due_date'). annotate (total_day = Sum ('sold_value')). order_by ('due_date')


Accounts Returns a List of Information Sorted by Due Date
groups returns another list sorted and grouped by due date

I would like django to place a total groups in the template below the line of accounts when it realizes that the next due date is different from the previous one, ie totaling by date.

Can someone help me?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8ea05b06-1eb1-4de3-8787-6d80570a6283%40googlegroups.com.


--

--
You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/fxaeopAyJj8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHBRYSeBvJr6cDTRtUXEqsJFb03cZw66G2jk1DqY_7P7-jYq1g%40mail.gmail.com.


--
Elias Coutinho.
Aprender sobre alguns assuntos é fundamental.
Aprender sobre Deus é indiscutivelmente o melhor conteúdo.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALgom8oa_fEfWMiyCdvr0cWGjKzB9Fk8fENkCjnvXOof%3DKMR%2Bg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP5HUWos_QUR1C2ZTHJreRVutVUEEEw_41sx94bPw6O4YUJqRg%40mail.gmail.com.

No comments:

Post a Comment