Given the following two models forming the base of a wiki-style app:
class Page(models.Model):
current_revision = models.IntegerField()
class PageContent(models.Model):
page = models.ForeignKey(Page)
revision = models.IntegerField()
created = models.DateTimeField()
Here, we have a canonical Page object with a current_revision that always
points to the most current revision, stored in PageContent. How can I
construct a Page queryset, ordered by the Pages that have the most
recently-created PageContent?
Currently, what I am doing is:
qs =
PageContent.objects.filter(revision=F('page__current_revision')).order_by('created').select_related()
pages = [content.page for content in qs]
This works fine, but is there a more straightforward way to do this?
Thanks,
Brad
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@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.
