/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 vote331 views1 answer
Cptac dataset
Python
3 votes344 views1 answer
Remove commas from string python
Python
0 vote362 views1 answer
Django clodinarystorage
Python
7 votes337 views4 answers
Tensorflow gpu test
Python
0 vote291 views1 answer
Nested dictionary to dataframe
Python
31 votes352 views4 answers
Python random generator from list
Python
-1 vote377 views2 answers
Python increment
Python
0 vote360 views2 answers
Poerty python macos
Python
0 vote345 views1 answer
Truc python
Python
0 vote348 views1 answer
Request.body django
Python