Django ORM: Filter on timedelta

Asked Jan 31 '19 at 14:37

Active Jan 31 '19 at 14:37

Viewed 180 times

I've got a field 'frequency' and i'd like use it in my filter.

My model:

class Foo(models.Model):
   name = models.CharField(max_length=50)
   frequency = models.IntegerField(default='60')
   last_checked = models.DateTimeField()

I'd like get my data some like it, but instead of '10' minutes I can put there 'frequency' field.

Foo.objects.filter(last_checked__lt=timezone.now()-timedelta(minutes=10))

How can i do this? Or maybe I shoud go other way? Thanks for helpful tips.

asked Jan 31 '19 at 14:37

dziorkowsky

3

Check out this answer: https://stackoverflow.com/a/46297988/1637351 See other comment for better suggestion. – schillingt Jan 31 '19 at 14:47
Actually this one is better: https://stackoverflow.com/a/41145600/1637351 It would use `DurationField` – schillingt Jan 31 '19 at 14:48

Django ORM: Filter on timedelta

0 Answers0