/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 vote246 views1 answer
Django import settings variables
Python Django
2 votes228 views4 answers
Django login required
Python Django
0 vote218 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python Django
1 vote235 views1 answer
How to send json in django response
Python Django
0 vote215 views1 answer
Pass query params django template
Python Django
4 votes227 views1 answer
Django is null
Python Django
0 vote231 views1 answer
Dockerize django app
Python Django
1 vote251 views1 answer
Url in form action django
Python Django
4 votes229 views3 answers
ArrayField in Django
Python Django
1 vote222 views1 answer
Django get id of newly created object
Python Django