/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

4 votes135 views2 answers
How to count range in django template
Python Django
0 vote165 views1 answer
Test if instance in queryset django
Python Django
0 vote146 views1 answer
Listing of django model types
Python Django
0 vote124 views2 answers
Django serializer method field read write
Python Django
0 vote127 views1 answer
Django month name from month number
Python Django
24 votes237 views6 answers
Django update model
Python Django
1 vote141 views1 answer
Number of database queries django
Python Django
0 vote131 views1 answer
Django bootstrap
Python Django
0 vote144 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python Django
1 vote141 views1 answer
Difference between get and filter in django
Python Django