/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 vote307 views1 answer
Django fixtures. To loaddata
Python Django
0 vote319 views1 answer
Django save another class data while saving a class
Python Django
0 vote298 views1 answer
Reading json without using relative path in django
Python Django
1 vote343 views2 answers
Redirect to the same page django
Python Django
0 vote283 views1 answer
Get users except superuser django
Python Django
-3 votes313 views1 answer
Django socketio web chat example
Python Django
-2 votes286 views1 answer
How to get the user argent in django
Python Django
0 vote309 views2 answers
Django run management command from code
Python Django
0 vote348 views1 answer
Django admin.py all fields
Python Django
0 vote403 views1 answer
Inspectdb django
Python Django