/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 vote210 views1 answer
How to create superuser in django heroku
Python Django
0 vote222 views1 answer
Demploy django in vps
Python Django
12 votes237 views5 answers
Django-cors-headers
Python Django
0 vote245 views2 answers
Generate random token or id in django
Python Django
0 vote218 views1 answer
Bootstrap 5 in Django
Python Django
6 votes221 views2 answers
Kill port django
Python Django
0 vote220 views1 answer
Get current url with parameters url django
Python Django
0 vote242 views1 answer
Using claudinary in django
Python Django
0 vote230 views1 answer
Delete migrations django and start over deployment heroku
Python Django
8 votes223 views2 answers
Purpose of meta class in django
Python Django