/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 vote205 views1 answer
Django on_delete rules
Python Django
1 vote224 views1 answer
Django celery results
Python Django
1 vote202 views1 answer
Django ckeditor not working
Python Django
0 vote220 views2 answers
Django model remove duplicates
Python Django
1 vote259 views2 answers
Django queryset unique values
Python Django
0 vote181 views1 answer
Django jwt custom authentication
Python Django
14 votes224 views6 answers
Install django
Python Django
0 vote213 views1 answer
Django cms api create page
Python Django
0 vote238 views1 answer
Django clodinarystorage
Python Django
0 vote234 views1 answer
Visitor IP address django
Python Django