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). Say there are 3 Users in an org : A, B and C with each creating 3,4,5 items respectively, and 'A' is the current user; then i need a query which returns all these items(i.e, 12 items) when i supply A.. -V -- 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.
