I have two models Article and Blog related using a foreign key. I want to select only blog name while extracting the article.
articles = Articles.objects.all().select_related('blog__name')
The query generated shows that it selected all the fields from the Blog model. I tried using only() and defer() with select_related but both didn't work out.
articles = Articles.objects.all().select_related('blog__name').only('blog__name', 'title', 'create_time')
The above query resulted in error: Invalid field name(s) given in select_related: Choices are: blog
How do i generate a query so that only article fields and blog name is selected?
You can use annotate() for this.
>>> a = Articles.objects.annotate(blog_name=F('blog__name')).first()
>>> a.title
>>> a.blog_name