/Python/Count items in a model django rest

Count items in a model django rest

CustomerInformation.objects.annotate(lead_count=Count('status',filter=Q(status="lead"))).annotate(client_count=Count('status',filter=Q(status="client")))

Source: stackoverflow.com

Count items in a model django rest

class CustomerInformation(models.Model):

    status = (
        ('lead', 'Lead'),
        ('client', 'Client'),
    )

    customer_name = models.CharField(max_length=100)
    status = models.CharField(max_length=100, choices=status, default='lead')
    creator = models.ForeignKey('UserProfile', related_name='customers', on_delete=models.CASCADE, null=True, blank=True)
    created_date = models.DateField(default=timezone.now)

Source: stackoverflow.com

Similar codes

0 vote208 views1 answer
How to get single element from arraylist in numpy arrayt
Python
10 votes197 views2 answers
Pygame get mouse position
Python
14 votes280 views1 answer
Average value of list elements in python
Python
1 vote209 views1 answer
Webhook discord files
Python
0 vote210 views1 answer
Ist comperension python
Python
0 vote211 views1 answer
Strategy forex with python
Python
22 votes202 views4 answers
Python is float
Python
2 votes216 views3 answers
To_frame python
Python
2 votes196 views1 answer
How to add headers in csv file using python
Python
1 vote337 views1 answer
Django sort descending
Python