/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

0 vote201 views1 answer
Fix the debug_mode = false django
Python Django
0 vote188 views1 answer
Get full detail inside of id in django rest framework many to many
Python Django
28 votes238 views1 answer
Import "matplotlib" could not be resolved django
Python Django
0 vote166 views1 answer
How to add condition if null value in django orm
Python Django
1 vote194 views1 answer
Updating many to many field in django using pk
Python Django
1 vote172 views1 answer
Django change value and save model object
Python Django
0 vote185 views1 answer
"api_view" is not defined django
Python Django
3 votes172 views2 answers
Postgres Database Django
Python Django
1 vote213 views3 answers
Value list in django
Python Django
0 vote190 views1 answer
How to use put method in django
Python Django