Why doesn't this Django filter by 'annotate' variable work?

Question

I have this queryset in Django:

obj = Obj.objects.annotate(duration = F('date_end') - F('date_start')).order_by('duration')

The following works perfectly:

obj[0].duration

obj.aggregate(Sum('duration'))['duration__sum']

However filtering doesn't work in this case even though documentation says that it should:

obj = obj.filter( duration__gte = <a_class_datetime.timedelta> )  # doesn't work
obj = obj.filter( duration = 1 )   # doesn't work

This is the error I am getting:

TypeError: expected string or bytes-like object

My way to bypass this issue is to loop through the dataset - which is huge. Any tips as to why this is not working?

JPG · Accepted Answer · 2019-10-10 04:11:27Z

2

You need to use Python's timedelta instance while filtering,

from datetime import timedelta

obj = obj.filter(duration__gte=timedelta(days=10))

Apart from that, use ExpressionWrapper to specify the output_field so that you can avoid unwanted errors.

from django.db import models

# for annotation
annotated_queryset = Foo.objects.annotate(
    duration=models.ExpressionWrapper(models.F('date_end') - models.F('date_start'),
                                      output_field=models.DurationField()))

# for filtering
from datetime import timedelta

filtered_queryset = annotated_queryset.filter(duration__gte=timedelta(days=10))

edited Oct 10, 2019 at 4:11

answered Oct 10, 2019 at 4:03

JPG

89.4k24 gold badges164 silver badges235 bronze badges

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

1 Comment

David Over a year ago

ExpressionWrapper with DurationField in this case works like a charm. Thanks.

Collectives™ on Stack Overflow

Why doesn't this Django filter by 'annotate' variable work?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related