/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 vote275 views1 answer
Queryset.raw() in django rest framework joining tables
Python Django
2 votes360 views3 answers
No such table django
Python Django
0 vote246 views1 answer
Make value of two tables unique django
Python Django
0 vote294 views1 answer
Load local data to django
Python Django
-1 vote243 views1 answer
Django email verification
Python Django
0 vote236 views1 answer
Date format django template filter
Python Django
1 vote306 views1 answer
Django get part of queryset
Python Django
0 vote247 views1 answer
Get ip address in django
Python Django
0 vote253 views1 answer
Django not saving images forms
Python Django
1 vote219 views1 answer
Convert pandas dataframe to django queryset
Python Django