Maybe:
paris_discounts = Discount.objects.filter( brand__shop__city__name =
'Paris' ).distinct('id')What do you think? 2012/11/9 ozgur yilmaz <yelb...@gmail.com>: > But Brand doesnt have a city field. Shop class has a city field. > > 2012/11/9 Jirka Vejrazka <jirka.vejra...@gmail.com>: >> paris_discounts = Discount.objects.filter(brand__city__name='Paris') ? >> >> Note that these are always *double* underscores and I had to make a guess >> that your City has an attribute "name". >> >> HTH >> >> Jirka >> >> >> >> On Fri, Nov 9, 2012 at 9:12 AM, ozgur yilmaz <yelb...@gmail.com> wrote: >>> >>> Hi all, >>> >>> I hope i can explain my query problem well. Think you have 3 classes: >>> >>> class City( models.Model ): >>> ... >>> ... >>> >>> class Brand( models.Model ): >>> ... >>> ... >>> >>> class Shop( models.Model ): >>> brand = models.ForeignKey( Brand ) >>> city = models.ForeignKey( City ) >>> ... >>> ... >>> >>> class Discount( models.Model ): >>> brand = models.ForeignKey( Brand ) >>> ... >>> ... >>> >>> Think a Shop sell products of a single Brand. I have lots of Discount >>> records. But i'm interested in Discounts at Shops in Paris. Is there >>> any? >>> >>> Can you help me? >>> >>> Thanks, >>> >>> -- >>> 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. >>> >> >> -- >> 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. -- 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.
