/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

0 vote210 views1 answer
Filters rows using the given condition
Python
0 vote194 views2 answers
Fix ImportError: No module named PIL
Python
0 vote192 views2 answers
Python parameter with default value and type
Python
18 votes180 views3 answers
Change specific column name pandas
Python
25 votes225 views3 answers
Anaconda virtual environment LIST
Python
0 vote191 views2 answers
Additionner liste python
Python
0 vote226 views2 answers
Python seperate int into digit array
Python
0 vote195 views1 answer
Slicing time series
Python
0 vote198 views1 answer
How to make an app like word in python
Python
1 vote289 views1 answer
Django queryset multiple filters
Python Django