On Wed, Jul 6, 2011 at 2:40 PM, akaariai <[email protected]> wrote: > Maybe this? > > user = current_user > user_org_employees = Employees.objects.filter(org=user.org) > user_org_items = > Items.objects.filter(created_by__in=user_org_employees) >
No, users can belong to multiple organizations, so no using user.org. Something like this: orgs = Organization.objects.filter(employees__user=user) users = User.objects.filter(employee__org__in=orgs) items = Item.objects.filter(created_by__in=users) Cheers Tom -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. 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.
