Re: Annotate on related field

By "retrieving the matching tags" you mean fetching `Tag` objects?

Well I guess what you can do is to use `prefetch_related` with custom `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+unsubscribe@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.