/Python/Django/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 vote129 views1 answer
Django queryset first element
Python Django
0 vote116 views1 answer
"DjangoJSONEncoder" is not defined
Python Django
1 vote122 views1 answer
Filter foreign fileds django_filters
Python Django
0 vote126 views1 answer
Django set random password
Python Django
0 vote136 views1 answer
Django template child data in nested loop
Python Django
0 vote148 views1 answer
How to add static files in django 3.2.9
Python Django
2 votes137 views2 answers
Super in django manager
Python Django
0 vote139 views1 answer
Sendgrid django smtp
Python Django
0 vote128 views1 answer
Import external script in django views
Python Django
1 vote136 views1 answer
How to create staff account in django
Python Django