/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 vote152 views1 answer
Django rest DjangoModelPermissions include get
Python Django
0 vote291 views1 answer
Django form custom validation
Python Django
0 vote147 views1 answer
Create django model field based on another field
Python Django
0 vote159 views1 answer
Merge two Querysets in Python Django while preserving Queryset methods
Python Django
3 votes157 views1 answer
Django import model from another app
Python Django
0 vote156 views2 answers
Generate random password django
Python Django
2 votes144 views1 answer
Django mysql
Python Django
1 vote158 views1 answer
Passing user instance django form submission
Python Django
0 vote155 views1 answer
Django get current user in form
Python Django
1 vote170 views1 answer
Django genericforeignkey null
Python Django