/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

85 votes175 views6 answers
For python
Python
0 vote205 views1 answer
Print python setencode
Python
62 votes173 views6 answers
Os get current directory
Python
8 votes181 views1 answer
Python generate uid
Python
5 votes158 views2 answers
Python how to put int into list
Python
0 vote176 views1 answer
TypeError: unhashable type: 'list' drop duplicates
Python
0 vote168 views1 answer
How to make a new key in a dictionary python
Python
71 votes178 views6 answers
Shuffle array python
Python
0 vote215 views1 answer
Flask server not reloading
Python Flask
13 votes191 views3 answers
Np.hstack
Python