/Python/Django/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

1 vote244 views2 answers
Django drop database postgres
Python Django
0 vote245 views1 answer
Django show image in admin page
Python Django
1 vote217 views3 answers
Django reverse
Python Django
30 votes290 views3 answers
Django createsuperuser
Python Django
0 vote232 views1 answer
How to specify port while running django project
Python Django
0 vote218 views1 answer
Pass query params django template
Python Django
0 vote268 views1 answer
Django custome login
Python Django
0 vote243 views1 answer
Django create object from dict
Python Django
0 vote223 views1 answer
How to add value in array django
Python Django
1 vote251 views2 answers
.save() in django
Python Django