/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

17 votes236 views2 answers
Install django using pip
Python Django
0 vote216 views1 answer
Django override form fields in admin
Python Django
0 vote213 views1 answer
Setting up a django prostgress project
Python Django
0 vote206 views1 answer
Django not detecting new model
Python Django
0 vote223 views1 answer
How to populate an image to template in django from views
Python Django
2 votes217 views3 answers
.first() in django
Python Django
3 votes276 views2 answers
Django get parameters from url
Python Django
0 vote210 views1 answer
Django fixtures. To dump data
Python Django
0 vote210 views1 answer
Django cms api
Python Django
0 vote185 views1 answer
Function of this cod in django in django performance = serializers.SerializerMethodField() # def get_performance(self, instance): # return PerformanceSerializer(instance.performance).data
Python Django