/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

14 votes107 views6 answers
Ruby print
Python
1 vote265 views1 answer
Batchnorm1d pytorch
Python
1 vote172 views1 answer
Python seaborn heatmap decrease annot size
Python
1 vote140 views1 answer
Jinja len is undefined
Python
2 votes137 views2 answers
Create pdf from images python
Python
0 vote142 views1 answer
Openpyxl add worksheet
Python
3 votes198 views1 answer
Business logic in django
Python Django
3 votes162 views3 answers
2d array python initialize
Python
12 votes158 views5 answers
Python create uuid
Python
0 vote278 views1 answer
Python print f
Python