/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 votes266 views4 answers
Latest version of django
Python Django
0 vote287 views1 answer
Django filter word count greater than
Python Django
1 vote344 views1 answer
How to redirect to another page in django after login
Python Django
0 vote288 views2 answers
How to avoid inserting duplicate records in orm django
Python Django
1 vote335 views2 answers
Django queryset unique values
Python Django
0 vote275 views1 answer
Ssl django nginx
Python Django
2 votes332 views2 answers
Count gabarit django
Python Django
0 vote346 views1 answer
Django month name from month number
Python Django
2 votes330 views1 answer
Auto datetime in django models
Python Django
17 votes311 views6 answers
Django model
Python Django