/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

1 vote377 views1 answer
Django get part of queryset
Python Django
0 vote354 views1 answer
Django raise 404
Python Django
0 vote357 views1 answer
Django from
Python Django
0 vote349 views1 answer
How to add phone number to django user model
Python Django
0 vote345 views1 answer
Django default template location
Python Django
0 vote370 views2 answers
How to use django-filters with viewset
Python Django
2 votes354 views3 answers
How to set indian timezone in django
Python Django
0 vote372 views1 answer
Use in in django while preserving order
Python Django
0 vote302 views1 answer
Django iterating through objects
Python Django
3 votes401 views1 answer
ModuleNotFoundError: No module named 'django.core.urlresolvers'
Python Django