/Python/Django/Django model query add annotation field to show duplicate count

Django model query add annotation field to show duplicate count

from django.db.models import OuterRef, Subquery, Count, Min

subquery = Product.objects.filter(bc_sku=OuterRef('bc_sku')).values('bc_sku')
                          .annotate(dup_count=Count('*'), min_price=Min('product_price'))
Product.objects.filter(product_type='good')
               .annotate(dup_count=Subquery(subquery.values('dup_count')), 
                         min_price=Subquery(subquery.values('min_price')))

Similar codes

0 vote217 views1 answer
Django.core.exceptions.ImproperlyConfigured: Field name is not valid for model
Python Django
0 vote218 views1 answer
Django jinja else if template tags
Python Django
25 votes393 views2 answers
Django create app command
Python Django
0 vote215 views2 answers
Django rest framework foreign key relation giving error in serializer
Python Django
4 votes238 views1 answer
Django forms set class
Python Django
1 vote221 views3 answers
Django reverse lazy
Python Django
1 vote238 views1 answer
Use django taggit in template
Python Django
0 vote233 views1 answer
What is NoReverseMatch in django?
Python Django
0 vote227 views1 answer
How to query json field django
Python Django
0 vote224 views1 answer
Remove last comma forloop django
Python Django