/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

1 vote174 views1 answer
Np.rand.randint
Python
1 vote145 views1 answer
Python find smallest value in 2d list
Python
2 votes161 views1 answer
Read a csv file in pandas
Python
8 votes187 views6 answers
Convert integer to binary python
Python
44 votes196 views5 answers
Python execute shell command
Python
0 vote189 views1 answer
F-string print
Python
12 votes189 views6 answers
Python 2d array
Python
0 vote182 views2 answers
Scikit learn decistion tree
Python
12 votes180 views3 answers
How to install dependencies python
Python
123 votes179 views6 answers
Input python
Python