/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 votes121 views5 answers
Adding the elements of a list in python
Python
0 vote156 views1 answer
Pyqgis
Python
4 votes151 views3 answers
Python os
Python
0 vote160 views3 answers
Python unittest mock
Python
0 vote194 views1 answer
Python generator for reading and writing file
Python
0 vote157 views1 answer
Python enum declare
Python
0 vote149 views3 answers
Pandas reading each xlsx file in folder
Python
3 votes148 views1 answer
How to change a string to small letter in python
Python
0 vote150 views1 answer
Float division in python
Python
14 votes154 views1 answer
Python cheat sheet pdf download
Python