/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 vote301 views1 answer
What is horse riding sport name
Python
4 votes296 views1 answer
Round python with list
Python
0 vote286 views1 answer
How to alight and place ipywidgets
Python
0 vote318 views1 answer
Jupyter notebook not opening
Python
1 vote277 views1 answer
Skeppy python
Python
4 votes295 views1 answer
Python manage.py runserver
Python
1 vote313 views1 answer
Python max with custom function
Python
1 vote331 views2 answers
Python read parquet
Python
5 votes312 views2 answers
Put comma in numbers python
Python
0 vote314 views2 answers
How to format integer to two digit in python
Python