how to get list of users that have posts in django?

Question

I'm trying to get a list of Users that have created at least one Post object. I want to do something like users = User.objects.filter(posts__not_null) How can I do this?

models.py

class Post(models.Model): user = models.ForeignKey(User, on_delete= models.CASCADE)

Thanks!

willeM_ Van Onsem · Accepted Answer · 2020-07-16 17:01:14Z

1

You can obtain this with:

User.objects.filter(post__isnull=False).distinct()

The .distinct() [Django-doc] is useful to prevent returning the same user that much times as there are Posts for that user.

answered Jul 16, 2020 at 17:01

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

1 Comment

winston Over a year ago

that worked perfectly, thank you! Great explanation as well. very helpful

Collectives™ on Stack Overflow

how to get list of users that have posts in django?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related