Filtering by group

[Alex]

I'm playing around with a TV quotes database and I'm trying to get all
quotes from one TV series. My problem is that the quotes are directly
tied to an episode of a TV series, not the series itself. How can I
easily get a queryset that represents all quotes from that series?

Here's a snippet from my models.py (removing irrelevant info):

class Source(models.Model):
    name = models.CharField(max_length=50)
    slug = models.SlugField(max_length=20)

class Quote(models.Model):
    quote = models.TextField(max_length=500)
    authors = models.ManyToManyField(Author)
    source = models.ForeignKey(Source)

class TVSeries(models.Model):
    name = models.CharField(max_length=50)
    slug = models.SlugField(max_length=20, editable=False)

class TVEpisode(Source):
    series = models.ForeignKey(TVSeries)
    episodenum = models.IntegerField()

In my view, I'm thinking of something like the following, which
obviously doesn't work:

queryset =
Quote.objects.filter(source=TVEpisode.objects.filter(TVSeries.objects.filter(authors__slug__iexact=slug)))

Is there an easy way to filter by groups like this?

Thanks,
Alex
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---