Timedelta between two fields

Question

I'm looking for objects where the timedelta between two fields is greater than a certain number of days.

Baiscally I have a date when a letter is sent, and a date when an approval is received. When no approval is received in let's say 30 days, then these objects should be included in the queryset.

I can do something like the below, where the delta is something static. However I don't need datetime.date.today() as a start but need to compare against the other object.

delta = datetime.date.today() - datetime.timedelta(30)
return qs.filter(letter_sent__isnull=False)\
    .filter(approval_from__isnull=True)\
    .filter(letter_sent__gte=delta)

Any pointer how to do this?

Answer 1

Sounds like you want to annotate with an F object. Something like this:

from django.db.models import DurationField, ExpressionWrapper, F

delta = datetime.timedelta(days=30)
expression = F('approval_from') - F('letter_sent')
wrapped_expression = ExpressionWrapper(expression, DurationField())
qs = qs.annotate(delta=wrapped_expression)
qs = qs.filter(delta__gte=delta)

Answer 2

You can also make it the other way around. Just keep F("num_days") outside of timedelta because timedelta doesn't know about F().

from datetime import timedelta
expression = F('approval_from') - timedelta(days=1) * F("num_days")
wrapped_expression = ExpressionWrapper(expression, DateTimeField())
qs = qs.annotate(letter_sent_annotation=wrapped_expression)
qs = qs.filter(letter_sent__gte=letter_sent_annotation)