On Wed, Jul 6, 2011 at 2:40 PM, akaariai <akaar...@gmail.com> 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 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.
