/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 vote341 views1 answer
Set colour to inserplaintext qtextedit in python
Python
17 votes335 views2 answers
Python calculate factorial
Python
0 vote332 views1 answer
Python pandas rellenar con ceros a la izquierda
Python
1 vote316 views1 answer
Jupyter notebook how to set max display row columns matrix numpy
Python
0 vote334 views1 answer
Destructuring in for loops python
Python
0 vote301 views1 answer
Python copy virtual env modules
Python
2 votes334 views1 answer
Use of == python
Python
0 vote378 views1 answer
How can i make a list of leftovers that are str to make them int in python
Python
2 votes372 views3 answers
Streamlit pip
Python
62 votes324 views6 answers
Python for loop with index
Python