/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 vote270 views1 answer
Unsupported media type django
Python Django
2 votes281 views1 answer
Django orm timestamp field
Python Django
1 vote253 views1 answer
Get current site django
Python Django
4 votes238 views1 answer
Django include
Python Django
10 votes255 views2 answers
Django import settings
Python Django
-4 votes243 views4 answers
Django latest version
Python Django
0 vote251 views1 answer
Django model make the field caseinsensitive
Python Django
0 vote249 views1 answer
Select default option django form
Python Django
1 vote254 views1 answer
Django createmany
Python Django
2 votes230 views1 answer
Register modal in django admin
Python Django