Django: Using F arguments in datetime.timedelta inside a query

by

Just avoid timedelta‘s F-ignorance

filter knows about F, but timedelta does not.
The trick is to keep the F out of the timedelta argument list:

ThatModel.objects.filter(
    last_datetime__lte=now + datetime.timedelta(seconds=1)*F("interval"))

This will work with PostgreSQL, but, alas, not with SQlite.

More Related Contents:

  1. Raise a validation error in a model’s save method in Django
  2. Django Queryset with filtering on reverse foreign key
  3. Can Django automatically create a related one-to-one model?
  4. Django Pass Multiple Models to one Template
  5. Django self-recursive foreignkey filter query for all childs
  6. How to resolve “django.core.exceptions.ImproperlyConfigured: Application labels aren’t unique, duplicates: foo” in Django 1.7?
  7. How to filter empty or NULL names in a QuerySet?
  8. How to view corresponding SQL query of the Django ORM’s queryset?
  9. In a django model custom save() method, how should you identify a new object?
  10. Unique fields that allow nulls in Django
  11. How to use the request in a ModelForm in Django
  12. Django – iterate number in for loop of a template
  13. Django Static Files Development
  14. How to convert a Django QuerySet to a list?
  15. Tying in to Django Admin’s Model History
  16. django class-based views with inline model-form or formset
  17. Django: accessing session variables from within a template?
  18. How do I add a Foreign Key Field to a ModelForm in Django?
  19. boto.exception.S3ResponseError: S3ResponseError: 403 Forbidden
  20. Can I call a view from within another view?
  21. “No ‘Access-Control-Allow-Origin’ header is present on the requested resource” in django
  22. django dynamically filtering with q objects
  23. How can I restrict Django’s GenericForeignKey to a list of models?
  24. Error “You’re accessing the development server over HTTPS, but it only supports HTTP”
  25. Adding root element to json response (django-rest-framework)
  26. Where to store secret keys DJANGO
  27. django query get last n records
  28. Can I use HTTP Basic Authentication with Django?
  29. Host Django on subfolder
  30. how to write a query to get find value in a json field in django

Leave a Comment