/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

19 votes153 views10 answers
Gme
Python
0 vote165 views1 answer
Python check if string contains one of characters list
Python
1 vote151 views1 answer
FizzBuzz FizzBuzz is a well known programming assignment, asked during interviews.
Python
0 vote155 views2 answers
Doing math in python
Python
0 vote154 views1 answer
Python how to add picture to label with tkinter
Python
16 votes205 views6 answers
Pip install pandas
Python
0 vote166 views1 answer
How to use startswith() with list
Python
23 votes152 views6 answers
Check tensorflow version
Python
49 votes140 views3 answers
Python write csv line by line
Python
0 vote154 views1 answer
Bad resolution in the exported RDKit images
Python