/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

17 votes109 views2 answers
How to learn python
Python
42 votes105 views3 answers
Replacing values in pandas dataframe
Python
0 vote106 views1 answer
Python no mathcing key method found
Python
2 votes111 views6 answers
How to download nltk in python
Python
0 vote147 views1 answer
Matplotlib bar chart value_counts
Python
0 vote115 views1 answer
Doomsday fuel foobar
Python
32 votes110 views1 answer
Pandas create new column
Python
0 vote134 views1 answer
"DO_NOTHING" is not defined django
Python Django
2 votes99 views1 answer
Model pickle file create
Python
62 votes112 views6 answers
Python loop with index
Python