/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 vote241 views1 answer
Django customize the user model
Python Django
0 vote245 views2 answers
Jsonresponse status code django
Python Django
0 vote248 views3 answers
Django custom authentication
Python Django
0 vote370 views2 answers
User logout in django rest framework
Python Django
29 votes414 views3 answers
Django admin create project
Python Django
0 vote180 views1 answer
Cant use foreign key in list_display django
Python Django
4 votes260 views4 answers
Filter django or
Python Django
1 vote232 views1 answer
Correr servidor django
Python Django
0 vote224 views1 answer
Add many instances to related field manytoamny django]
Python Django
8 votes297 views2 answers
Django create empty migration
Python Django