/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 vote249 views1 answer
Django nested inlines
Python Django
1 vote227 views1 answer
Require http method django view
Python Django
1 vote240 views2 answers
Django print query
Python Django
0 vote281 views1 answer
Aggregation with f() in django rest api
Python Django
19 votes290 views6 answers
Install Django Windows
Python Django
0 vote270 views1 answer
Django charfield force lowercase
Python Django
1 vote239 views1 answer
Ls.ProgrammingError: permission denied for table django_migrations
Python Django
0 vote273 views1 answer
How to set default user group in django
Python Django
0 vote303 views1 answer
Restaurant management system in django
Python Django
0 vote241 views1 answer
Django admin.py date format
Python Django