On Jul 5, 10:06 pm, Venkatraman S <venka...@gmail.com> wrote: > I tried asking around in IRC, and stumbled on a few possible solutions, > would be great if someone shed some more light: > > I have the following models: > > class Organization(models.Model): > name = models.CharField(max_length=100, blank=False) > > class Employees(models.Model): > org = models.ForeignKey(Organization, > related_name='employees') > user = models.ForeignKey(User) > name = models.CharField(max_length=100, blank=False) > > class Item(models.Model): > name = models.CharField(max_length=100, blank=False) > created_by = > models.ForeignKey(User,related_name='created_by_whom') > > Problem : I need to get all Items from the Organization to which current > User belongs to. > So basically, get all employees from the Org that the current User belongs > to, and then get all items created by these employees. (So, this query > should also include the current User).
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) - Anssi -- 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.
