/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

5 votes401 views2 answers
Django connexion session time
Python Django
1 vote209 views1 answer
How to get last values or data in django orm
Python Django
1 vote222 views1 answer
Django proper capitalization case jinja
Python Django
1 vote240 views2 answers
Django get settings
Python Django
2 votes239 views2 answers
What is role of ALLOWED_HOSTs in Django
Python Django
0 vote218 views1 answer
Check django channels with redis setup
Python Django
1 vote210 views1 answer
Sum values in django models
Python Django
0 vote227 views1 answer
Django content type for model
Python Django
0 vote241 views2 answers
Django domain name
Python Django
1 vote230 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django