hello www, This is the model:
from django.contrib.auth.models import User class Task(models.Model): creator = models.ForeignKey(User) assigned_to = models.ManyToManyField(User) And there are four users: bob, roger, dan and joe I want to get all the tasks where the current user is the creator or where he's assigned to. I tried this request: requests = Request.objects.filter(Q(assigned_to=request.user) | Q(by=request.user)) or this one, which is the same : requests = Request.objects.filter(Q(assigned_to__in=[request.user]) | Q(by=request.user)) Problem: I have a task, bob is the creator, roger, dan and joe are assigned to it. The request returns the same result three times (i.e. [Task(pk=1), Task(pk=1), Task(pk=1)] Do you have an idea about why? And how can I get only unique results? Thanks, -- niluje -- 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.