Hello, While writing a forum app, I ran into a problem: I am unable to sort a list of threads by date of their latest post.
My models look like: class Thread(models.Model): club = models.ForeignKey(Club) name= models.CharField(_('Thread'), max_length=100) date = models.DateTimeField(auto_now = True ) def __unicode__(self): return self.name class Post(models.Model): thread = models.ForeignKey(Thread) date = models.DateTimeField(auto_now=True) subject = models.CharField(_('Subject'), max_length=100) text = models.TextField(_('Text')) def __unicode__(self): return self.subject I know that I can get the date of the latest post of a thread by using: Thread.objects.get(id=3).post_set.all().latest('date').date However, I do not know if there is any possibility of me using that date to sort a QuerySet of threads, which I get by using Thread.objects.filter(club=1). Is there any way to do this in Django? Many thanks for your help! Wim --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---