/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

0 vote260 views1 answer
Pytohn reset all dictionary values to 0
Python
2 votes269 views2 answers
Check if string has capital letter python
Python
0 vote259 views1 answer
Raspberry pi pygame play thru bluetooth device
Python
0 vote266 views1 answer
Return positon of ele in list python
Python
18 votes252 views4 answers
How to play audio in python
Python
0 vote253 views1 answer
Python list to sublists
Python
0 vote235 views1 answer
Cv2.flip
Python
30 votes262 views2 answers
Python install pil
Python
0 vote242 views1 answer
Full dist upgrade kali
Python
0 vote252 views1 answer
Python correlation between features and target
Python