/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

2 votes148 views1 answer
Tcs python interview questions
Python
0 vote181 views1 answer
Getting Random rows in dataframe
Python
2 votes191 views1 answer
Python force string parameter
Python
8 votes179 views1 answer
Python alphabet capital
Python
-3 votes199 views6 answers
Python 3.3 release date
Python
0 vote280 views1 answer
Count how many loops that printed in python
Python
50 votes189 views6 answers
Python plot
Python
19 votes192 views5 answers
Conda tensorflow
Python
13 votes177 views1 answer
Change background color of tkinter
Python
0 vote189 views1 answer
Clear text box tkinter python
Python