/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 vote450 views1 answer
Django admin.py all fields
Python Django
0 vote423 views1 answer
Django refresh form db
Python Django
1 vote382 views2 answers
Django url static
Python Django
14 votes387 views4 answers
Django delete
Python Django
1 vote403 views1 answer
Add search field to django admin
Python Django
-4 votes348 views4 answers
Latest version of django
Python Django
0 vote389 views1 answer
Dynamic footer in django
Python Django
0 vote437 views1 answer
Django Abstract base classe
Python Django
1 vote414 views2 answers
Django print query
Python Django
0 vote386 views1 answer
Django raise 404
Python Django