Фильтрация модели иностранного ключа из модели иностранного ключа
Пытаюсь отфильтровать все объекты productimg из MainProduct, но получаю ValueError Cannot use QuerySet for "MainProduct": Use a QuerySet for "Product"., но не могу использовать slug или id для фильтрации из Product, потому что это домашняя страница
home:view [не работает]
#can't use slug here
def home(request):
mainproduct = MainProduct.objects.all()
productimg = ProductImage.objects.filter(
#wanna access all productimg objects of a single product i.e mainproduct
product=mainproduct
)
shop:view [works]
def detail_view(request, slug):
products = Product.objects.get(slug=slug)
productimg = ProductImage.objects.filter(product=products)
shop:model
class Product(models.Model):
name = models.CharField(max_length=150)
class ProductImage(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE)
image = models.ImageField(null=True, blank=True, upload_to='somewhere/')
home:model
class MainProduct(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE)
title = models.CharField(max_length=50)
mainproduct is not a ingle product: it is a QuerySet of all MainProducts, even if there is a single MainProduct. If there is exactly one MainProduct, you query with .get(…) [Django-doc]:
def home(request):
mainproduct = MainProduct.objects.get()
productimg = ProductImage.objects.filter(
product__mainproduct=mainproduct
)
# …