Many thanks Malcolm. That nailed it. So simple when you know how! MerMer
On Apr 19, 2:56 am, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Wed, 2007-04-18 at 23:28 +0100, Merric Mercer wrote: > > I'm have the following three Models. > > > 1.Category Model > > > 2. Promotion Model > > - Has a many to many relationship with Category. > > - Is the Parent of the Cash Model. > > > 3.Cash Model > > - Has one to one relationship with Promotion. > > > I want to create a query set of Cash Objects, filtered by a specific > > Category.id > > > I'm sure that there must be simple solution - but having looked through > > the forums I just can't figure how to do it. > > > Can anybody please advise. > > Wtihout seeing your models (what you called the fields, etc) it's hard > to be precise, but the following should do what you want: > > Cash.objects.filter(promotion__category=6) > > I'm assuming the one-to-one field in Cash is called "parent" and the > Category field in Promotion is called "category". > > Regards, > Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
