/Python/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

140 votes286 views6 answers
Python random integer in range
Python
13 votes276 views1 answer
Python read file to variable
Python
0 vote361 views1 answer
Python NameError: name 'io' is not defined
Python
0 vote307 views1 answer
Python pandas get dataframe element
Python
27 votes273 views2 answers
Time py
Python
5 votes279 views1 answer
Window size cv2
Python
1 vote282 views1 answer
Accessing dictionary elements in python
Python
0 vote290 views1 answer
Print fps in while loop python
Python
0 vote263 views1 answer
Jupyter today date
Python
-2 votes322 views2 answers
Python eol
Python