/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 vote240 views1 answer
Decode in django templates
Python Django
2 votes199 views1 answer
Python optionmenu tkinter
Python
3 votes205 views2 answers
How to download youtube playlist using python
Python
4 votes355 views5 answers
Min max python
Python
0 vote192 views2 answers
Stop animation matplotlib
Python
6 votes215 views4 answers
Python restart script
Python
1 vote203 views2 answers
One hot encoding numpy
Python
1 vote186 views2 answers
Unpack list python
Python
-1 vote183 views1 answer
How to block a ip adress
Python
0 vote206 views1 answer
Python how to print something at a specific place
Python