/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 vote209 views1 answer
Compress tarfile python
Python
0 vote203 views1 answer
Select default option django form
Python
6 votes215 views5 answers
Format in python
Python
0 vote239 views2 answers
How to schedule python script in windows
Python
0 vote193 views2 answers
Python3 ngrok.py
Python
0 vote196 views1 answer
Django custome login
Python
12 votes217 views2 answers
Read excel file spyder
Python
0 vote230 views1 answer
How to set text in qdateedit pyqt5
Python
5 votes204 views4 answers
Execute command and get output python
Python
0 vote199 views2 answers
Check instance has an attribute in python
Python