How to get count from two columns in django queryset?

Question

models.py

class Friend(models.Model):
    creator = models.ForeignKey(Individual, related_name="friendship_creator_set", blank=True, null=True)
    friend = models.ForeignKey(Individual, related_name="friend_set", blank=True, null=True)
    active = models.BooleanField(default=False, blank=True)
    confirm = models.BooleanField(default=False, blank=True)
    created_at = models.DateTimeField(auto_now_add=True, auto_now=False)
    modified_at = models.DateTimeField(auto_now_add=False, auto_now=True)

I am adding this two query to get the result:

Friend.objects.filter(creator_id=value, confirm=True).count() + Friend.objects.filter(friend_id=value, confirm=True).count()

How can convert it to a single queryset in Django?

Sayse · Accepted Answer · 2019-10-16 08:29:22Z

1

You just need to do an or condition..

from django.db.models import Q
Friend.objects.filter(Q(creator_id=value) | Q(friend_id=value), confirm=True).count()

answered Oct 16, 2019 at 8:29

Sayse

43.4k14 gold badges85 silver badges150 bronze badges

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

Collectives™ on Stack Overflow

How to get count from two columns in django 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