I am trying to count the distinct values from a group of objects that have a manytomanyfield
e.g.
object article has manytomanyfield of tag objects
one article has tags "tag1" "tag2"
another article has tags "tag2" "tag3"
I would like to figure out something that would return something along the lines of:
"tag1": 1 "tag2": 2 "tag3": 1
I thought I could do something with articles.objects.all().values('tags') or something but I came up empty.
class Topping(models.Model):
name = models.CharField(max_length = 20)
class Pizza(models.Model):
name = models.CharField(max_length = 20)
toppings = models.ManyToManyField(Topping)
python manage.py shell
>>> from many_to_many.models import Pizza, Topping
>>> t1 = Topping(name = "T1")
>>> t2 = Topping(name = "T2")
>>> t3 = Topping(name = "T3")
>>> t4 = Topping(name = "T4")
>>> p1 = Pizza(name="P1")
>>> p2 = Pizza(name="P2")
>>> p1.toppings.add(t1)
>>> p1.toppings.add(t2)
>>> p2.toppings.add(t2)
>>> p2.toppings.add(t3)
>>> t2.pizza_set.count()
2
>>> t1.pizza_set.count()
1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With