/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 vote439 views2 answers
Django admin image
Python Django
0 vote282 views1 answer
Django orm group by month and year
Python Django
0 vote329 views1 answer
How to insert a placeholder text in django modelform
Python Django
0 vote317 views1 answer
Django create ap
Python Django
2 votes309 views1 answer
Django flush database
Python Django
0 vote326 views1 answer
Login views django template passing
Python Django
3 votes300 views1 answer
No module named 'django.core.urlresolvers'
Python Django
1 vote301 views1 answer
Django httpresponseredirect
Python Django
1 vote345 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django
0 vote313 views1 answer
Django not saving images forms
Python Django