/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 vote167 views1 answer
Read api from django
Python Django
0 vote185 views1 answer
Create a django and react readonly web app
Python Django
0 vote184 views1 answer
How to create api for get data in django rest framework
Python Django
1 vote166 views1 answer
Django print settings
Python Django
2 votes167 views2 answers
Or operator django
Python Django
3 votes170 views1 answer
Django group by
Python Django
-1 vote171 views1 answer
Email validation using django
Python Django
2 votes125 views2 answers
Django admin actions
Python Django
0 vote163 views1 answer
Input function in django
Python Django
0 vote168 views1 answer
Django queryset to instance
Python Django