/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 vote284 views3 answers
How to create a sub project in django
Python Django
0 vote251 views1 answer
Django python base 64 encode
Python Django
0 vote260 views1 answer
Cbv uk django
Python Django
1 vote245 views1 answer
Db_index django
Python Django
1 vote255 views1 answer
Django get form id from request
Python Django
0 vote245 views1 answer
Function of this cod in django in django performance = serializers.SerializerMethodField() # def get_performance(self, instance): # return PerformanceSerializer(instance.performance).data
Python Django
1 vote266 views1 answer
Django reverse queryset
Python Django
8 votes238 views6 answers
Django filters
Python Django
0 vote234 views1 answer
Heroku how to access config vars django
Python Django
0 vote256 views1 answer
Cannot cast type smallint to boolean django
Python Django