/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 vote421 views1 answer
Django queryset with multiple contain keyword
Python Django
9 votes333 views1 answer
Delete object from table django
Python Django
0 vote337 views1 answer
Pass query params django template
Python Django
0 vote338 views1 answer
Django how to create superuser if does not exists on migration
Python Django
0 vote402 views1 answer
Django get group users
Python Django
0 vote355 views1 answer
Django create view class
Python Django
2 votes365 views2 answers
Django-admin command not found
Python Django
0 vote330 views4 answers
Pip django graphql
Python Django
2 votes322 views1 answer
Django mysql
Python Django
0 vote349 views1 answer
Django date grater
Python Django