problems with order by month

[Osvaldo Ruso Olea]

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)

[Matthew Pava]

Try this:

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

--
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...@googlegroups.com.
To post to this group, send email to django...@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.

[Osvaldo Ruso Olea]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/ae37d6672adc41f8bd4fc4187c27df80%40ISS1.ISS.LOCAL.

[Matthew Pava]

You can chain the methods.

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPJtaPDoPie6B4fVUyMKojNMfwYXrJqwU3ZyGm6ny3TdmHg46Q%40mail.gmail.com.

[Osvaldo Ruso Olea]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/546f450d00ad4d73bf993db6dcb5f2be%40ISS1.ISS.LOCAL.

[Franklin Sarmiento]

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 ( frankl...@gmail.com )

E-mail: frankl...@gmail.com

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/546f450d00ad4d73bf993db6dcb5f2be%40ISS1.ISS.LOCAL.

[Franklin Sarmiento]

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 ( frankl...@gmail.com )

E-mail: frankl...@gmail.com

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPJtaPArH6r%3DrfD%3DAdbQMUNUA%3DdsZyuWziB7ZJZ6zCNjXpS14w%40mail.gmail.com.

[Osvaldo Ruso Olea]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMsjBKLF8EsoTTt2Fa2wpC9McZj6BxC0PAgxam8LDqbubuexmw%40mail.gmail.com.

[Osvaldo Ruso Olea]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/546f450d00ad4d73bf993db6dcb5f2be%40ISS1.ISS.LOCAL.

[Phako Perez]

I think you miss the column to order

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

Should be

cardio = Alumno.objects.filter ( fechanacimiento __month = now.month).order_by(‘fechanacimiento_day’)  

Sent from my iPhone

[Franklin Sarmiento]

hi Osvaldo, try filtering by date ( by month and date ), do you can filter by month and day ??? if this is what do you want, so, you  can filter by date by example: "fechanacimiento__date", so, the queryset sould be this:

Alumno.objecs.filter(.....).order_by('fechanacimiento__date') # by default is ascending, for descending add the "-" before the order keyword, by example "-fechanacimiento__date"

Good look.

____________________________________________________

Franklin Sarmiento

Full-stack developer

skype: franklin.s.dev

Twitter: @franklinitiel

linkedin: Franklin Sarmiento ( frankl...@gmail.com )

E-mail: frankl...@gmail.com

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

--

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...@googlegroups.com.
To post to this group, send email to django...@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/66567EB6-0843-47ED-BB24-5F7753BE169F%40gmail.com.