/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

1 vote251 views2 answers
Python detect internet connection
Python
58 votes271 views6 answers
String list to int list python
Python
0 vote296 views1 answer
Python request post with json with headers
Python
0 vote263 views1 answer
Voting classifier grid search
Python
0 vote314 views1 answer
Install python-dev packages
Python
3 votes266 views1 answer
Python3 return a list of indexes of a specific character in a string
Python
55 votes264 views5 answers
How to clear the console python
Python
0 vote290 views1 answer
Decorator patter
Python
1 vote252 views1 answer
How to change the rate of speech in pyttsx3
Python
2 votes271 views1 answer
Random date python
Python