/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 vote346 views1 answer
Python use cases
Python
2 votes347 views3 answers
Pandas print dataframe without index
Python
0 vote331 views1 answer
Gtk entry not editable python
Python
3 votes391 views2 answers
Pandas normalize columns
Python
73 votes319 views6 answers
Remove duplicates python
Python
-1 vote352 views1 answer
Matplotlib limit number of ticks
Python
1 vote337 views1 answer
Palindrome Check using for loop in python
Python
0 vote341 views1 answer
Df add value at first index
Python
0 vote360 views1 answer
Question 2 Let's create a function that turns text into pig latin: a simple text transformation that modifies each word moving the first character to the end and appending "ay" to the end. For example, python ends up as ythonpay.
Python
37 votes374 views3 answers
How to send emails in python
Python