/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 vote234 views1 answer
Django model specify table name
Python Django
0 vote228 views2 answers
Django form formatting
Python Django
25 votes308 views3 answers
Startapp django
Python Django
0 vote245 views1 answer
Django BruteBuster error failed attempts
Python Django
3 votes232 views4 answers
Django setup in windows
Python Django
1 vote278 views1 answer
Django genericforeignkey null
Python Django
1 vote267 views1 answer
Insert data in django models
Python Django
0 vote237 views1 answer
Django admin no such table user
Python Django
0 vote248 views1 answer
Argumrnt with reverse django
Python Django
-1 vote229 views1 answer
Django migrate not creating tables
Python Django