/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

13 votes396 views2 answers
Delete database entry using name django
Python Django
0 vote349 views1 answer
Lose your django secret key
Python Django
2 votes395 views3 answers
Get absolute url django
Python Django
1 vote381 views1 answer
Get most repeated instance in a queryset django
Python Django
0 vote317 views2 answers
Avoid bad request django
Python Django
4 votes289 views2 answers
Check installed django version
Python Django
-4 votes355 views4 answers
Django latest version
Python Django
1 vote359 views1 answer
Django filter not equal to
Python Django
5 votes369 views2 answers
Django admin password reset
Python Django
0 vote368 views1 answer
Django.core.exceptions.FieldError: 'date' cannot be specified for Forum model form as it is a non-editable field
Python Django