/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 vote234 views1 answer
Django sign up
Python Django
5 votes251 views4 answers
Django get or 404
Python Django
2 votes248 views1 answer
Django static media
Python Django
0 vote263 views1 answer
Current page django
Python Django
0 vote237 views1 answer
Django include all columns admin show
Python Django
1 vote243 views2 answers
Check db calls django
Python Django
2 votes253 views1 answer
Auto datetime in django models
Python Django
2 votes313 views1 answer
How to save bulk create in django
Python Django
4 votes178 views2 answers
Check installed django version
Python Django
1 vote252 views1 answer
How to add captcha in django forms
Python Django