/Python/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

2 votes254 views1 answer
Download pdf from link using python
Python
0 vote299 views1 answer
Which game engine is best
Python
0 vote292 views1 answer
Difference between changing values of variable and list inside function in python
Python
0 vote301 views1 answer
Django raise 404
Python Django
18 votes244 views5 answers
Python auto clicker
Python
0 vote287 views1 answer
Python - convert a list column into miltiple columns
Python
1 vote275 views1 answer
Python enum
Python
0 vote269 views1 answer
Python die
Python
1 vote291 views1 answer
Speech enhancement technique
Python
1 vote283 views1 answer
Conda import django
Python