/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 vote158 views1 answer
Django form field class
Python Django
1 vote161 views1 answer
Django populate choice field from database
Python Django
0 vote153 views1 answer
Django.core.exceptions.ImproperlyConfigured: Application labels aren't unique, duplicates: auth
Python Django
0 vote203 views1 answer
Django only certain columns from database
Python Django
0 vote171 views1 answer
Django serializer,
Python Django
1 vote165 views5 answers
Django social auth
Python Django
0 vote159 views1 answer
Django querset group by sum
Python Django
2 votes173 views1 answer
Pass in queryset as filter django
Python Django
0 vote159 views1 answer
Form valid django created by
Python Django
1 vote180 views1 answer
Django urlpattern
Python Django