django orm filter from other queryset

Question

i m on my mini project and have a problem. this is my models

class Post(models.Model):
    user = models.ForeignKey(User, related_name='poster_user', db_index=True)
    post_content = models.CharField(max_length=500, blank=True, null=True)
    post_date = models.DateTimeField(default=datetime_now)
    numberof_comment = models.BigIntegerField(default=0)
    is_deleted = models.BooleanField(default=False)

class Follower(models.Model):
    user = models.ForeignKey(User, related_name='user', db_index=True)
    isFriendToUser = models.ForeignKey(User, related_name='isFriendToUser', db_index=True)
    is_deleted = models.BooleanField(default=False)
    lastModifiedDate = models.DateTimeField(default=datetime_now)

when i have

followinguser = Follower.objects.all().filter(user=user, is_deleted=False)

and use it to

Post.objects.filter(user=followinguser.isFriendToUser, is_deleted=False)

it returned error Cannot use QuerySet for "follower": Use a QuerySet for "User". i want to have query like this:

select * from Post 
where 
    user in (select isFriendToUser from Follower where user='someuserobject' and is_deleted = 0)
    AND
    is_deleted = 0

Well have fun debugging it, if you need help ask a descriptive question, explaining what the error is as well as what you have tried and researched to try to solve the issue. — Sayse
– Sayse, Commented Apr 22, 2016 at 7:52
error: Cannot use QuerySet for "follower": Use a QuerySet for "User". — Mahyar
– Mahyar, Commented Apr 22, 2016 at 7:53

Ozgur Vatansever · Accepted Answer · 2016-04-22 07:59:56Z

2

If I understand correctly what you want to do:

Post.objects.filter(user__in=followinguser.values_list("isFriendToUser", flat=True), is_deleted=False)

answered Apr 22, 2016 at 7:59

Ozgur Vatansever

52.5k17 gold badges89 silver badges122 bronze badges

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

Collectives™ on Stack Overflow

django orm filter from other 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