As far as I know, that's fine. Michael J. could use
City.objects.exclude(jobs_isnull=True) to accomplish what he seemed to
be going for.

On May 7, 2:09 am, Eric Abrahamsen <[EMAIL PROTECTED]> wrote:
> I've been using something like:
>
> City.objects.filter(jobs__isnull=True)
>
> It seems to work, but I'd really like to know if this is undesirable  
> for any reason.
>
> On May 6, 2008, at 8:05 PM, Dmitriy Kurilov wrote:
>
>
>
> > Hi.
>
> > # models
>
> > class City(models.Model):
> >    # Fields...
>
> > class Job(models.Model):
> >    city = models.ForeignKey(City, related_name="jobs")
> >    # Other fields
>
> > # views
> > City.objects.filter(jobs__pk__gt=0)
>
> > Is it?
>
> > -----Original Message-----
> > From: Michael J <[EMAIL PROTECTED]>
> > To: Django users <django-users@googlegroups.com>
> > Date: Tue, 6 May 2008 16:29:20 -0700 (PDT)
> > Subject: Traversing a backward relationship
>
> >> I hope this isn't a stupid question, so forgive me in advance.
>
> >> I have a Job model and a City model. Job and City are linked via a
> >> ForeignKey in Job. On the website, users will select a city, from a
> >> list of cities, and then see the corresponding jobs.
>
> >> Question is: how do I use the database API to only show cities that
> >> have jobs?
--~--~---------~--~----~------------~-------~--~----~
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