/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 vote223 views1 answer
Import CreateAPIView django
Python Django
2 votes279 views2 answers
Django queryset is in list
Python Django
0 vote230 views1 answer
How to specify port while running django project
Python Django
0 vote227 views2 answers
Django model remove duplicates
Python Django
0 vote218 views1 answer
How to console log in django heroku
Python Django
3 votes243 views1 answer
Autoslugfield django 3
Python Django
4 votes287 views2 answers
Change django admin title
Python Django
1 vote252 views1 answer
Django httpresponseredirect
Python Django
1 vote240 views1 answer
Django sites framework
Python Django
7 votes271 views2 answers
Ckeditor django
Python Django