/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 vote215 views1 answer
What is serialization in django
Python Django
0 vote223 views1 answer
Instal django impoer expor
Python Django
1 vote242 views1 answer
Import status in django rest framework
Python Django
11 votes193 views3 answers
Django q filter
Python Django
0 vote151 views12 answers
Installez django-cruds-adminlte
Python Django
0 vote231 views1 answer
How to update image in django
Python Django
0 vote209 views1 answer
Django serializer,
Python Django
0 vote222 views1 answer
Created by and updated by in django
Python Django
11 votes221 views6 answers
Django create user
Python Django
0 vote208 views2 answers
How to JOIN three tables with Django ORM
Python Django