/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 vote126 views1 answer
How to add phone number to django user model
Python Django
2 votes130 views1 answer
Django queryset get all distinct
Python Django
3 votes135 views1 answer
Django admin prefetch_related
Python Django
0 vote135 views1 answer
Django set random password
Python Django
0 vote132 views1 answer
Django vs code extensions
Python Django
0 vote91 views12 answers
Installez django-cruds-adminlte
Python Django
2 votes130 views1 answer
Django models distinct
Python Django
-1 vote137 views1 answer
Django email verification
Python Django
2 votes161 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python Django
3 votes142 views2 answers
Django change user password
Python Django