/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

22 votes103 views5 answers
How to check if a word is a palindrome in python
Python
0 vote89 views1 answer
How to invert a true false array in python
Python
0 vote96 views1 answer
Python numpy array check if all nans
Python
0 vote95 views1 answer
Flask mongoengine getting started
Python
32 votes98 views6 answers
Get count of unique values in column pandas
Python
5 votes100 views2 answers
Selenium scroll to element python
Python
0 vote110 views1 answer
Newtorkx remove node
Python
1 vote99 views1 answer
Filter foreign fileds django_filters
Python
0 vote108 views1 answer
Add readme cmd
Python
9 votes102 views4 answers
Json timestamp to date python
Python