/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 votes180 views6 answers
Django orm
Python Django
0 vote176 views1 answer
Django bootstrap
Python Django
5 votes227 views2 answers
My django template doesnt want to load the static file
Python Django
0 vote197 views1 answer
Django auto increment field
Python Django
1 vote190 views1 answer
Filter with different operator in django
Python Django
6 votes204 views4 answers
Django change password command line
Python Django
0 vote149 views1 answer
Django jwt custom authentication
Python Django
0 vote179 views1 answer
Reading json without using relative path in django
Python Django
0 vote182 views1 answer
Select Children of an Object With ForeignKey in Django?
Python Django
1 vote252 views1 answer
Add help text in Django model forms
Python Django