Something like that should do it: org = Organization.objects.get(slug="single-organization") tickets = Ticket.objects.select_related.filter(user__organization_id = org.id) or maybe even tickets = Ticket.objects.select_related.filter(user__organization__slug = "single-organization")
Regards, Aidas Bendoraitis [aka Archatas] On 11/16/06, Giorgio Salluzzo <[EMAIL PROTECTED]> wrote: > > I've got some Organization, where each one has some User. A User can > write a Ticket. > > How can I filter all the Ticket for a single Organization? > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---