/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

14 votes193 views6 answers
Installing django on windows
Python Django
0 vote209 views1 answer
Django dumpdata specific app
Python Django
0 vote211 views1 answer
Hpw to create related model in django rest framework logic
Python Django
0 vote173 views1 answer
How to add value in array django
Python Django
0 vote188 views1 answer
Django.com
Python Django
0 vote206 views1 answer
Else if in django template
Python Django
8 votes194 views6 answers
Redirect django
Python Django
0 vote173 views1 answer
Django bootstrap
Python Django
1 vote124 views1 answer
Django template decimal places
Python Django
0 vote184 views1 answer
Django models for existing database
Python Django