/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

3 votes214 views1 answer
Django import model from another app
Python Django
0 vote191 views1 answer
How to add column to heroku postgres in my django app
Python Django
0 vote183 views1 answer
How to add phone number to django user model
Python Django
3 votes198 views1 answer
Django queryset group by
Python Django
0 vote206 views1 answer
Django form field add attrs
Python Django
0 vote231 views1 answer
Overriding update in serializer django
Python Django
0 vote194 views1 answer
Django pass list of fields to values
Python Django
0 vote256 views1 answer
Inspectdb django
Python Django
23 votes269 views3 answers
Install django rest_framework
Python Django
1 vote225 views1 answer
Django manager
Python Django