Re: problems with order by month

try this but it does not work, keep ordering by year, and not by day ascending

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

• 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      
• 
  
• try this but it did not work

  Alumno.objects.filter(........).order_by('fechanacimiento__month') if you want to filter descending so with the "-" before the "fechanacimiento__month" by example:

  
  

  Alumno.objects.filter(........).order_by('-fechanacimiento__month') # descending
  

  Alumno.objects.filter(........).order_by('fechanacimiento__month') # by default ascending.
  

  
  and then
  
  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')

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/CAPJtaPC%2Bg956x9o9wkJ6VmUi%3DqrmpVHX9eNOZ2nEdJ_BVL-2sg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.