Ok. I 'll try again Thank you very much for your consideration. Regards,
Gontran On 29 mar, 09:33, Kenneth Gonsalves <law...@thenilgiris.com> wrote: > Product is not linked to them - they are linked to Product. I do not > think you can do it in one query because there are ManyToMany fields > which have to be retrieved and then you have to iterate over them. > Certainly more than one query. > > > > > > > > > > On Tue, 2011-03-29 at 00:24 -0700, gontran wrote: > > Yes: ProductLicence and News > > > On 29 mar, 09:19, Kenneth Gonsalves <law...@thenilgiris.com> wrote: > > > On Tue, 2011-03-29 at 00:11 -0700, gontran wrote: > > > > UserProfile(models.Model): > > > > user = models.OneToOneField(User) > > > > company = models.ForeignKey(Company) > > > > > Company(models.Model): > > > > product_licences = models.manyToManyField(ProductLicence) > > > > > Product(models.Model): > > > > ...some fields... > > > > > ProductLicence(models.Model): > > > > product = models.ForeignKey(Product) > > > > > News(models.Model): > > > > related_products = models.ManyToManyField(Product) > > > > > I already know how to retrieve all distinct products for which the > > > > company of the user owns licences, but now, what I want to do is to > > > > retrieve all news, for a given user, that are related to products, for > > > > which the company of the user owns licences. > > > > Product is not linked to any model? > > > -- > > > regards > > > KGhttp://lawgon.livejournal.com > > > Coimbatore LUG roxhttp://ilugcbe.techstud.org/ > > -- > regards > KGhttp://lawgon.livejournal.com > Coimbatore LUG roxhttp://ilugcbe.techstud.org/ -- 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.
