/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

2 votes418 views2 answers
Count gabarit django
Python Django
0 vote354 views1 answer
Django populate form from database
Python Django
0 vote397 views1 answer
Django check if user is staff in template
Python Django
0 vote355 views1 answer
Django trim string whitespace
Python Django
6 votes363 views3 answers
Django filter install
Python Django
4 votes377 views2 answers
Loginrequiredmixin django
Python Django
0 vote436 views1 answer
Django admin.py all fields
Python Django
3 votes340 views1 answer
Django flush
Python Django
2 votes380 views1 answer
Django template capitalize equivalent
Python Django
0 vote494 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python Django