/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 vote310 views1 answer
Insurance= contract.x_studio_social_security_basic salary of ins = 1500 result = contract.x_studio_social_security_basic_salary*100
Python
0 vote367 views1 answer
Spotify meist gespielte lieder sehen
Python
0 vote259 views1 answer
How many Python Programmers in the world
Python
-1 vote340 views1 answer
Pandas merge_asof direction
Python
11 votes359 views3 answers
What is // in python
Python
1 vote312 views1 answer
DHT22 raspberry pi zero connector
Python
0 vote320 views1 answer
Macos youtube-dl unable to get local issuer certificate _ssl.c:1131
Python
0 vote328 views1 answer
How to find mean of one column based on another column in python
Python
12 votes303 views3 answers
Python program to add two numbers with user input
Python
5 votes335 views1 answer
Pandas split dataframe to train and test
Python