Vfrdtyky

I made a query that goes like this:

LLDPE = Inventory.objects.filter(rm_type='LLDPE')

Basically, I'm trying to get the quantity per rm_type that is named LLDPE. my models look something like this:

class Inventory(models.Model):



    RM_TYPES = (

        ('--', '----------------'),

        ('LDPE', 'Low-density polyethylene'),

        ('LLDPE', 'Linear low-density polyethylene'),

        ('HDPE', 'High-density polyethylene'),

        ('PP', 'Polypropylene'),

        ('PET', 'Polyethylene terephthalate')

    )



    item_type = models.CharField('item_type', choices=ITEM_TYPES, max_length=200, default='Not specified', null=True, blank=True)

    rm_type = models.CharField('rm_type', choices=RM_TYPES, max_length=200, default='Not specified', null=True, blank=True)

    quantity = models.IntegerField()

Use .count() method to get the quantity on an specific queryset. Here is the doc

count()

Returns an integer representing the number of objects in the database
matching the QuerySet.

In your example, try this:

LLDPE = Inventory.objects.filter(rm_type='LLDPE').count()

But, if you want to aggregate every rm_type, you should use django aggregation.