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 <[email protected]> wrote: > Well, the result I expect is a list with subtotals similar to the figure > below: > > [image: image.png] > > Can you do it without javascript? > > Em sáb., 30 de nov. de 2019 às 03:36, Dvenum <[email protected]> > 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 <[email protected]> >> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/8ea05b06-1eb1-4de3-8787-6d80570a6283%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/8ea05b06-1eb1-4de3-8787-6d80570a6283%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> -- >> dvenum >> [email protected] >> >> -- >> 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 >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAHBRYSeBvJr6cDTRtUXEqsJFb03cZw66G2jk1DqY_7P7-jYq1g%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAHBRYSeBvJr6cDTRtUXEqsJFb03cZw66G2jk1DqY_7P7-jYq1g%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CALgom8oa_fEfWMiyCdvr0cWGjKzB9Fk8fENkCjnvXOof%3DKMR%2Bg%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CALgom8oa_fEfWMiyCdvr0cWGjKzB9Fk8fENkCjnvXOof%3DKMR%2Bg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP5HUWos_QUR1C2ZTHJreRVutVUEEEw_41sx94bPw6O4YUJqRg%40mail.gmail.com.
