/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 vote368 views2 answers
Django content type
Python Django
0 vote355 views1 answer
Django-multivaluedictkeyerror-error
Python Django
0 vote369 views1 answer
Django force download file
Python Django
0 vote365 views1 answer
Django model make the field caseinsensitive
Python Django
30 votes469 views6 answers
How to create a superuser in django
Python Django
1 vote375 views1 answer
How to use query_params in get_object djangorestframework
Python Django
1 vote430 views1 answer
How to redirect to another page in django after login
Python Django
0 vote369 views1 answer
Django raise 404
Python Django
0 vote402 views1 answer
Travis deployment script for django applications to heroku
Python Django
2 votes411 views2 answers
Get_absolute_url django
Python Django