/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 vote196 views1 answer
Django get group users
Python Django
0 vote163 views1 answer
Django test postgres extensions intarray
Python Django
-1 vote167 views1 answer
What is admin.tabularinline django
Python Django
3 votes103 views2 answers
Django favicon
Python Django
1 vote175 views1 answer
Django genericforeignkey null
Python Django
0 vote96 views1 answer
Get value of variable in session django
Python Django
0 vote245 views1 answer
Django force download file
Python Django
0 vote152 views1 answer
User passes test django
Python Django
0 vote161 views1 answer
Abstract user in django
Python Django
0 vote172 views1 answer
How to redirect in django rest framework
Python Django