/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 vote234 views1 answer
Telnet python
Python
0 vote210 views2 answers
Matplotlib grid in background
Python
1 vote243 views1 answer
Python remove one element from numpy array
Python
0 vote205 views1 answer
Rectangle function numpy
Python
0 vote218 views1 answer
Mypy clear cache
Python
1 vote203 views1 answer
The name tf.train.Optimizer is deprecated. Please use tf.compat.v1.train.Optimizer instead.
Python
0 vote231 views1 answer
Increase colorbar ticksize
Python
0 vote202 views1 answer
2checkout python
Python
37 votes157 views4 answers
Python pick random from list
Python
0 vote278 views1 answer
Fromhex python 2.7
Python