Actually there it is, users = models.ManyToManyField(User, symmetrical=True)
but I want to filter only the reports that contain only this user, or exclude the ones that do not have the user. Thanks again On 28 sep, 20:16, luismmontielg <luismmonti...@gmail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---