/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

3 votes339 views2 answers
Button images in tkinter
Python
7 votes323 views3 answers
Rmse in python
Python
10 votes375 views6 answers
Swap case python
Python
1 vote338 views3 answers
How to get today weekday in python
Python
1 vote349 views1 answer
Pandas python group by for one column and sum another column
Python
25 votes352 views6 answers
Create new python environment
Python
5 votes360 views2 answers
Django form password field
Python Django
87 votes357 views6 answers
For loops python
Python
0 vote317 views1 answer
How to load multiple list of dictionary values which is stored in python file and load into another python file in python over loop
Python
1 vote347 views2 answers
Boxplot show values seaborn
Python