/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 vote190 views3 answers
Django custom authentication
Python Django
0 vote181 views1 answer
AttributeError: module 'django.db.models' has no attribute 'ArrayField'
Python Django
1 vote186 views1 answer
Passing user instance django form submission
Python Django
2 votes199 views2 answers
Django filter and condition
Python Django
1 vote188 views1 answer
Counter in django template
Python Django
0 vote207 views2 answers
Blog in django
Python Django
1 vote220 views1 answer
Add search field to django admin
Python Django
1 vote199 views3 answers
Django logout user
Python Django
0 vote141 views1 answer
Add data to foreign key table django
Python Django
0 vote187 views1 answer
Make value of two tables unique django
Python Django