Group records in queryset

Viewed 23

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
0 Answers
Related