/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

0 vote293 views1 answer
How to add column to heroku postgres in my django app
Python Django
0 vote302 views1 answer
Django jinja else if template tags
Python Django
0 vote271 views1 answer
Django datepicker mindate and maxdate
Python Django
0 vote269 views1 answer
Django get child element
Python Django
0 vote331 views1 answer
Include app in django project
Python Django
0 vote293 views1 answer
Django filter word count greater than
Python Django
3 votes285 views3 answers
Simple jwt django
Python Django
1 vote281 views1 answer
Django login redirect
Python Django
7 votes288 views2 answers
Ckeditor django
Python Django
1 vote283 views1 answer
Django get id of newly created object
Python Django