that brings me all reports that have that user, but also the reports
that have user and user2.. i want only the reports that have 1 user
and id is equal to user.id
On Sep 29, 4:35 am, Joshua Russo <josh.r.ru...@gmail.com> wrote:
> oh ok, so just use the filter(user_id = user.id)
>
> On Tue, Sep 29, 2009 at 12:21 AM, luismmontielg
> <luismmonti...@gmail.com>wrote:
>
>
>
>
>
> > 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
-~----------~----~----~----~------~----~------~--~---
