/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

1 vote170 views1 answer
Django filter by date range
Python Django
0 vote162 views1 answer
Django loginview?
Python Django
1 vote179 views1 answer
How to multiply in django template
Python Django
0 vote174 views1 answer
Django default template location
Python Django
1 vote172 views2 answers
No changes detected in app django
Python Django
0 vote180 views1 answer
Django tempalte tag datetime to timestamp
Python Django
1 vote161 views1 answer
Django don't redirect on submission
Python Django
-1 vote178 views1 answer
Django filter on related field
Python Django
0 vote166 views1 answer
Add row in db django
Python Django
0 vote171 views1 answer
Delete all historical data django simple history
Python Django