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
-~----------~----~----~----~------~----~------~--~---

Reply via email to