I have the following models in an django app.
class Person(models.Model):
name = models.CharField(max_length=50)
class Product(models.Model):
owner = models.ForeignKey(Person, on_delete=models.CASCADE)
class Order(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE)
buyer = models.ForeignKey(Person, on_delete=models.CASCADE)
I would like to get a list of orders placed by a buyer grouped according to the owner of the product in the order.
Something like this
orders placed by buyer 1
order__product__owner 1
order 1
order 2
order 3
order__product__owner 2
order 4
order 5
order 6