Django: getting objects with ids from queryset

Question

I have these models (names are changed):

class Blog(models.Model):
    created_dtm = models.DateTimeField()
    updated_dtm = models.DateTimeField()
    title = models.CharField(max_length=200, null=True, blank=True)
    creator = models.ForeignKey(Authors, on_delete=models.CASCADE, null=True, blank=True)

class BlogAuthor(models.Model):
    blog = models.ForeignKey(Blog, on_delete=models.CASCADE)
    author = models.ForeignKey(Author, on_delete=models.CASCADE)
    class Meta:
        unique_together = ('blog', 'author')

and I need to get all Blogs(and its details) in which author is involved. The problem is that each Blog can have more than one author.

Now I can get query set of Blog's ids using this:

BlogAuthor.objects.filter(author=request.user).values_list('blog_id', flat=True)

and then try getting every single Blog one by one using cycle for, but is it possible to get list of Blogs with one query?

neverwalkaloner · Accepted Answer · 2018-07-04 17:05:08Z

1

Just use reverse relation:

Blog.objects.filter(blogauthor__author=request.user)

edited Jul 4, 2018 at 17:05

answered Jul 4, 2018 at 16:59

neverwalkaloner

47.6k7 gold badges101 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django: getting objects with ids from queryset

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related