sorry forgot to mention its a many to many relation so a report can have multiple users
On Sep 28, 4:29 pm, Joshua Russo <josh.r.ru...@gmail.com> wrote: > On Mon, Sep 28, 2009 at 7:55 PM, luismmontielg <luismmonti...@gmail.com>wrote: > > > > > > > > > Hello, > > I have my models like this... > > > class Report(models.Model): > > title = models.CharField(max_length=50, blank=True) > > users = models.ManyToManyField(User, symmetrical=True) > > categories = models.ManyToManyField("Category", > > through='ReportDetail', \ > > symmetrical=True) > > > I would like to get all reports from 1 user, but that only contain > > that user > > > I was looking for ne, not equals, but its removed, I cant do it with > > the exclude: > > I want to make something like this > > user = User.objects.get(pk=1) > > user_reports = user.report_set.exclude(users__id__NOTEQUAL = user.id) > > > how can I achieve this? > > I'm not sure I completely follow, but user.report_set only gives you reports > for the associated user, and it seems like that is what you want. You don't > need any further filters or excludes. > > For future reference: > exclude(user_id__ne = user.id) > is the same as > filter(user_id = user.id) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---