Access manyTomany field (Label) from category class via subclass(Products) Category-> Products -> Labels

Question

Here is the code of my models file:

from django.db import models

# Create your models here.

class Category(models.Model):
    name = models.CharField(max_length=255)

    def __str__(self):
        return self.name

class Product(models.Model):
    category = models.ForeignKey(Category, on_delete=models.CASCADE, related_name='products')
    name = models.CharField(max_length=255)
    price = models.DecimalField(decimal_places=2, max_digits=9)

    def __str__(self):
        return self.name

class Label(models.Model):
    name = models.CharField(max_length=255)
    products = models.ManyToManyField(Product,  related_name='labels')

    def __str__(self):
        return self.name

Now I want to access manyTomany field i.e. Label from Category please help me

Thanks in advance

Answer 1

You can try like this.

# first get the single category object 
category = Category.objects.get(pk=1)
# querying products in this category 
products = category.products.all()
# now filter the Label model based on the category products 
labels = Label.objects.filter(products__in=products)