/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

1 vote247 views1 answer
Set time complexity python
Python
0 vote222 views1 answer
Python max function with lambda
Python
2 votes223 views1 answer
Python filedir
Python
0 vote267 views1 answer
Parallel run of a function with multiple arguments partial
Python
0 vote177 views1 answer
Replace all string in list python
Python
7 votes214 views3 answers
Sum of a numpy array
Python
0 vote217 views1 answer
Corona data with python flask get pdf
Python
40 votes214 views2 answers
String to list
Python
-1 vote213 views2 answers
Python selenium find element by text
Python
1 vote193 views1 answer
Flask click submit button
Python Flask