/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

22 votes328 views6 answers
How to check django version
Python Django
7 votes297 views3 answers
How to display data in ascending order in django
Python Django
-2 votes265 views1 answer
Django e docker
Python Django
0 vote283 views1 answer
Get value of 1 field in model django
Python Django
0 vote265 views1 answer
Unique file name in django
Python Django
0 vote286 views1 answer
Load local data to django
Python Django
0 vote318 views1 answer
Using default as none in django mdoels
Python Django
0 vote270 views1 answer
Static Assets in Django
Python Django
0 vote281 views2 answers
How to JOIN three tables with Django ORM
Python Django
4 votes284 views3 answers
ArrayField in Django
Python Django