Django, filtering mysql database

Question

I have due_date column in DB and trying to filter rows by the value of that column. So the values in the column looks like "2020-01-20" and I am trying to filter it till year and month. NOT till Day In the function below:

def retrieve(request):

    date = "2020-01"       

    tasks = Task_Histories.objects.all().filter(due_date=date)
    serializer = InvocesSerializer(invoces, many=True)
    return Response(serializer.data)

How can I arrange DB column value before matching it in the filter()?

Horatiu Jeflea · Accepted Answer · 2020-03-04 09:04:00Z

2

Use startswith so you can filter by month or by year, or millennium :)

Task_Histories.objects.filter(due_date__startswith=date)

answered Mar 4, 2020 at 9:04

Horatiu Jeflea

7,4747 gold badges42 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

yvl Over a year ago

this little touch saved me a lot. Thank you. will accept it.

JPG · Accepted Answer · 2020-03-04 09:10:20Z

1

Assuming you are using the Django DateField in your models. If so, use __year and __month filter

tasks = Task_Histories.objects.filter(due_date__year='2020',due_date__month='01')

answered Mar 4, 2020 at 9:10

JPG

89.4k24 gold badges164 silver badges235 bronze badges

Collectives™ on Stack Overflow

Django, filtering mysql database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related