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.