/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

0 vote141 views2 answers
Business logic code where located in django rest framework
Python Django
54 votes301 views2 answers
How to run django requirement.txt
Python Django
0 vote172 views1 answer
Print choicefield data from database in django
Python Django
0 vote195 views1 answer
Http404 django
Python Django
1 vote186 views1 answer
Pip install django celery results
Python Django
0 vote190 views1 answer
Django change foreign key
Python Django
0 vote183 views1 answer
India states django choices
Python Django
5 votes188 views4 answers
Get user django
Python Django
0 vote214 views2 answers
Generate-thumbnails-in-django-with-pil
Python Django
0 vote177 views2 answers
How to get a specific field in django
Python Django