/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 vote160 views1 answer
Django choicefield empty label
Python Django
0 vote133 views1 answer
Run django localhost server
Python Django
4 votes163 views4 answers
How to change django admin text
Python Django
1 vote134 views1 answer
Django get model class from queryset
Python Django
0 vote176 views1 answer
How to set default user group in django
Python Django
0 vote141 views1 answer
Change date format on django templates
Python Django
30 votes240 views6 answers
How to create a superuser in django
Python Django
2 votes143 views4 answers
Django login required
Python Django
0 vote147 views1 answer
How to get data from multiple tables in django
Python Django
1 vote169 views1 answer
Updating many to many field in django using pk
Python Django