/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 vote168 views1 answer
Return an RDD containing all pairs of elements with matching keys in self and other.
Python
2 votes164 views2 answers
Combination without repetition python
Python
0 vote187 views1 answer
Plt force axis numbers
Python
0 vote154 views2 answers
Django swagger
Python
2 votes163 views2 answers
Python how to sum two lists
Python
8 votes178 views3 answers
How to install whl file in python
Python
6 votes215 views6 answers
Suicide
Python
0 vote211 views1 answer
Subtract constant from list
Python
0 vote172 views1 answer
Pd.read_csv how to cumsum a column
Python
3 votes152 views3 answers
Send dm to user discord.py
Python