/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 vote184 views1 answer
Django retrieveupdatedestroyapiview
Python Django
0 vote186 views1 answer
HTTP Error 403: Forbidden django using sendgrid
Python Django
0 vote184 views1 answer
Extends template django file system
Python Django
0 vote167 views1 answer
How to get parent model object based on child model filter in django
Python Django
0 vote273 views3 answers
Django forms I cannot save picture file
Python Django
0 vote209 views1 answer
Django admin.py all fields
Python Django
3 votes174 views3 answers
Simple jwt django
Python Django
8 votes166 views3 answers
Django order by
Python Django
-1 vote168 views2 answers
Django view
Python Django
0 vote177 views1 answer
Django raw without sql injection
Python Django