Annotate a List of Values

[Matthew Pava]

I am trying to annotate a list of values on a queryset.

Basically, I have a model of Items that are associated many to many to Serial Numbers, and I want for each distinct Item the list of all Serial Numbers for that Item.

[Nate Granatir]

As demonstrated here: https://docs.djangoproject.com/en/1.10/topics/db/examples/many_to_many/

If you have a ManyToMany relationship set up in your models, say:

class SerialNumber(models.Model):
    serial = models.CharField(max_length=50)

class Item(models.Model):
    item_name = models.CharField(max_length=100)
    serial_numbers = models.ManyToManyField(SerialNumber)

Then you can get a list of all serials for an item with:

item.serial_numbers.all()