/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 vote156 views1 answer
Install selenium python mac anaconda
Python
0 vote166 views1 answer
Python declare variables from dictionary
Python
35 votes170 views6 answers
Python for loop range
Python
6 votes218 views2 answers
Flask form options
Python Flask
0 vote168 views1 answer
ModuleNotFoundError: No module named 'textract'
Python
0 vote169 views1 answer
Python string: .title()
Python
1 vote161 views3 answers
Insertion sort calculator
Python
0 vote161 views1 answer
Algebraic pyramid python
Python
2 votes175 views3 answers
Python rotate list
Python
0 vote174 views1 answer
Base64 python flask html
Python Flask