/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

1 vote327 views1 answer
While not equal python
Python
0 vote345 views2 answers
Computation failed in `stat_flow()`:
Python
2 votes322 views1 answer
Absolute value columns pandas
Python
0 vote308 views1 answer
Infinity range or infinity looping
Python
0 vote297 views1 answer
Read excel file in computer
Python
0 vote330 views1 answer
Display full length jupyter
Python
1 vote293 views1 answer
How to remove seconds from datetime in python
Python
1 vote326 views1 answer
How to open dialog box to select files in python
Python
0 vote329 views1 answer
Arch linux python 3.7
Python
1 vote334 views1 answer
Find unique values in all columns in Pandas DataFrame
Python