/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 vote326 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python Django
0 vote305 views2 answers
Django-filter
Python Django
1 vote341 views1 answer
Unresolved reference 'django'
Python Django
1 vote325 views1 answer
Get csrf_token value in django template
Python Django
1 vote294 views2 answers
Django client ip
Python Django
0 vote326 views1 answer
Django post request 403 forbidden
Python Django
0 vote313 views1 answer
Django form field add attrs
Python Django
0 vote409 views1 answer
Rebuild database from zero django postgres
Python Django
0 vote308 views2 answers
Django get all models
Python Django
0 vote331 views1 answer
Django email change sender name
Python Django