/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 votes191 views3 answers
Python get current file location
Python
-1 vote197 views1 answer
How to reduce the image files size in python
Python
-1 vote210 views1 answer
Python find if part of list is in list
Python
6 votes175 views3 answers
Python timestamp
Python
1 vote187 views2 answers
Build dataframe from dictionary
Python
10 votes187 views6 answers
How to show a progress bar in python
Python
4 votes188 views3 answers
Matplotlib xticks font size
Python
0 vote189 views1 answer
Print out a name in python
Python
1 vote183 views1 answer
How to create a cube in ursina
Python
0 vote185 views1 answer
Stellargraph python
Python