Yes, almost. It got me to understand the correct syntax. I noticed that my results were coming according to Industry's primary key, rather than the Industry integer field, so I appended another __industry
Here is the solution: Project.objects.filter(campaign__industry__industry=x) Thank you for your guidance, Todd. On Thu, Jan 29, 2009 at 12:33 PM, Todd O'Bryan <toddobr...@gmail.com> wrote: > > I'm not sure I understand what you're asking, but > > projs = Project.objects.filter(campaign__industry=x) > > where x is one of 1-6 should do what you want, I think. > > Is that what you were asking? > > On Thu, Jan 29, 2009 at 9:54 AM, Kyle <thinki...@gmail.com> wrote: > > > > Hello! > > > > I am trying to get a list of "Projects" based on certain "Industry". > > (My naming convention, not django's) > > > > My models look like this: > > http://dpaste.com/114308/ > > > > "Project" has a foreign key to "Campaign". > > > > "Industry" also has a foreign key to "Campaign". > > > > Does it matter if both relationships are pointing to the center model > > in the data route I am trying to setup? Like this: > > > > Project -> Campaign <- Industry > > > > If Industry = 3, and a handful of Campaigns are returned, I would like > > a list of all the Projects contained in each of the Campaigns > > returned. > > > > How do I do this with django models? > > > > > > > > > > > -- Light Emitter Think in 3D Studios www.thinkin3d.net --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
