Tuesday, August 21, 2018

Re: problems with order by month

Try this:

Alumno.objects.filter(........).order_by('fechanacimiento__month', 'fechanacimiento__day')

Alumno.objects.filter(........).order_by('fechanacimiento__month, fechanacimiento__day')

Alumno.objects.filter(........).order_by('fechanacimiento__month').order_by('fechanacimiento__day')


____________________________________________________
Franklin Sarmiento
Full-stack developer
skype: franklin.s.dev
Twitter: @franklinitiel
linkedin: Franklin Sarmiento ( franklinitiel@gmail.com )
Teléfono(s): +57 320 490.79.64 / +58 426 273.8103 ( whatsapp )



El mar., 21 ago. 2018 a las 12:57, Osvaldo Ruso Olea (<venkotandil@gmail.com>) escribió:
I have problems ordering the date per day in ascending order.
thanks to your answer I have managed to filter the list for the current month, but unfortunately it is sorted by year and not by day in ascending order

def cardio(request):
    now = timezone.now()
    cardio = Alumno.objects.filter(fechanacimiento__month=now.month).order_by("fechanacimiento")
    contexto = {'cardio':cardio}
    return render(request, 'cardio.html', contexto)

this is the result that I have achieved

Lista

  • 2 Ago. 1943
  • 15 Ago. 1948
  • 28 Ago. 1948
  • 13 Ago. 1959
  • 21 Ago. 1962
  • 7 Ago. 1967
  • 5 Ago. 1970
  • 24 Ago. 1970
  • 27 Ago. 1970
  • 5 Ago. 1971
  • 26 Ago. 1971
  • 2 Ago. 1973
  • 4 Ago. 1973
  • 23 Ago. 1973
  • 11 Ago. 1977
  • 3 Ago. 1978
  • 23 Ago. 1979
  • 27 Ago. 1980
  • 11 Ago. 1981
  • 8 Ago. 1982
  • 23 Ago. 1982
  • 23 Ago. 1982
  • 15 Ago. 1983
  • 20 Ago. 1983
  • 15 Ago. 1984
  • 19 Ago. 1985
  • 8 Ago. 1986
  • 14 Ago. 1986
  • 29 Ago. 1986
  • 5 Ago. 1988
  • 25 Ago. 1988
  • 31 Ago. 1988
  • 27 Ago. 1990
  • 21 Ago. 1991
  • 22 Ago. 1991
  • 27 Ago. 1991
  • 14 Ago. 1992
  • 6 Ago. 1993
  • 13 Ago. 1993



El mar., 21 ago. 2018 a las 10:14, Matthew Pava (<Matthew.Pava@iss.com>) escribió:

You can chain the methods.

cardio = Alumno.objects.filter ( fechanacimiento __month = now.month).order_by('fechanacimiento')

 

 

From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Osvaldo Ruso Olea
Sent: Monday, August 20, 2018 9:49 PM
To: django-users@googlegroups.com
Subject: Re: problems with order by month

 

You are a genius, thank you very much, it worked perfectly, I just made one more modification

 

def cardio (request):

     now = timezone.now ()

     cardio = Alumno.objects.filter ( fechanacimiento __month = now.month)

     context = {'cardio': cardio}

     return render (request, 'cardio.html', context)

 

What I can not do is sort the dates from lowest to highest,

 

Thank you very much

 

El lun., 20 ago. 2018 a las 19:03, Matthew Pava (<Matthew.Pava@iss.com>) escribió:

Try this:

cardio = Alumno.objects.filter(fechanacimiento__month=timezone.now().month)

 

From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Osvaldo Ruso Olea
Sent: Monday, August 20, 2018 2:58 PM
To: Django users
Subject: problems with order by month

 

Hi how are you, I have problems filtering and sorting by date, precisely per month.

my intention is to filter the database for birthdays in the current month.

 

 

 

 

def cardio(request):

    cardio = Alumno.objects.order_by('fechanacimiento')

    contexto = {'cardio':cardio}

    return render(request, 'cardio.html', contexto)

--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e9f385a8-6b62-4e15-9020-9aa79ee7c48d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/ae37d6672adc41f8bd4fc4187c27df80%40ISS1.ISS.LOCAL.
For more options, visit https://groups.google.com/d/optout.

--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPJtaPDoPie6B4fVUyMKojNMfwYXrJqwU3ZyGm6ny3TdmHg46Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/546f450d00ad4d73bf993db6dcb5f2be%40ISS1.ISS.LOCAL.
For more options, visit https://groups.google.com/d/optout.

--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPJtaPArH6r%3DrfD%3DAdbQMUNUA%3DdsZyuWziB7ZJZ6zCNjXpS14w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMsjBKLF8EsoTTt2Fa2wpC9McZj6BxC0PAgxam8LDqbubuexmw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment