Something like this? backends = [backend1,backend2,backend3] latest_status = Status.objects.filter(backend__in=backends).latest()
Regards, Dmitry On Sep 29, 7:36 pm, Colin <cwoo...@gmail.com> wrote: > Hi Users, > > So I have a DB that has a list of backends and there properties and I > have a table that gets updated with if it is able to access and the > status. It is only updated when it is reported down or, if it was > reported down and is currenly back up. > > What i want to do is make a queryset that will get only the latest > status for a list of backends. > > #models.py > > class Backend(models.Model): > src_host = models.CharField(max_length=255) > ip = models.CharField(max_length=45) > port = models.CharField(max_length=8) > endpoint_name = models.CharField(max_length=255) > service_prop_name = models.CharField(max_length=255) > endpoint_url = models.CharField(max_length=255) > > class Status(models.Model): > backend = models.ForeignKey(Backend) > timestamp = models.DateTimeField() > status = models.CharField(max_length=255) > > class Meta(): > get_latest_by = 'timestamp' > > What I would like to do is get the latest status reported for the last > ten minutes. Without having to loop through a list querysets and > performing the .latest() function on it. > > Is this possible? > > Thanks, > > Colin -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
