Re: problems with order by month

The best solution is:

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.

Good look!.

____________________________________________________

Franklin Sarmiento

Full-stack developer

skype: franklin.s.dev

Twitter: @franklinitiel

linkedin: Franklin Sarmiento ( franklinitiel@gmail.com )

E-mail: franklinitiel@gmail.com

Teléfono(s): +57 320 490.79.64 / +58 426 273.8103 ( whatsapp )

El mar., 21 ago. 2018 a las 8:15, 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/CAMsjBKLjNYBh7JP0%3Dan-Rc4GxFRwt%2BhNoEYwjt1RMRCmyqKGYg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.