By "retrieving the matching tags" you mean fetching `Tag` objects?
Well I guess what you can do is to use `prefetch_related <https://docs.djangoproject.com/en/1.9/ref/models/querysets/#prefetch-related>` with custom `Prefetch <https://docs.djangoproject.com/en/1.9/ref/models/querysets/#django.db.models.Prefetch>` object. blogs = Blog.objects.prefetch_related( models.Prefetch('tags', queryset=Tag.objects.filter(name__in=['python', 'java']) to_attr='my_tags' ) ) #usage for blog in blogs: print blog.my_tags On Tuesday, July 12, 2016 at 2:28:30 PM UTC+3, Ramashish Baranwal wrote: > > Hi, > > I have the following model definitions: > > class Tag(models.Model): > name = models.CharField(max_length=16) > > class Blog(models.Model): > name = models.CharField(max_length=16) > tags = models.ManyToManyField(Tag, blank=True) > > > > I want to select blogs with more than one tags. Here is what I am doing > (for two tags)- > > # select blogs for python and java > blogs = Blog.objects.filter(tags__name='python').filter(tags__name='java') > > > > This INNER joins Tag with Blog twice, each time filtering on the given > name. This works well. Now I want to retrieve the matching tags. If it were > a single join, I would have done- > > blogs = blogs.annotate(tag=F('tags__name')) > > Doing this still works, but only retrieves the last tag. How do I retrieve > the tag name for each join, giving them different names? Something like- > > # Below should give tag1 = 'python', tag2 = 'java' > blogs = blogs.annotate(tag1=?, tag2=?) > > Thanks, > Ramashish > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e148c289-6f10-4f6d-a892-8b31f85a3887%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
