/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

2 votes250 views2 answers
How to multiply two arrays in python
Python
39 votes248 views6 answers
Creating dataframe
Python
0 vote202 views1 answer
New print on the same line substitution python 3
Python
0 vote232 views1 answer
405 status code django
Python Django
0 vote203 views1 answer
Python interpreter pip
Python
0 vote190 views1 answer
Tuples as return values
Python
0 vote274 views1 answer
Django retrieveupdatedestroyapiview
Python
0 vote188 views1 answer
Following Links in Python
Python
3 votes159 views1 answer
Use column as index pandas
Python
-1 vote208 views1 answer
Sort dict based on other list
Python