/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 vote221 views1 answer
Django validate_comma_separated_integer_list
Python
12 votes299 views4 answers
How to add array in python
Python
0 vote237 views1 answer
Jupyter early exit cell
Python
6 votes240 views1 answer
Write a Python program to append text to a file and display the text.
Python
0 vote251 views1 answer
Lambda Functions using for loop
Python
0 vote259 views1 answer
Opencv read gif
Python
3 votes220 views1 answer
Delete a key value pair from a dictionary in python
Python
2 votes229 views2 answers
How to check if user is using main file or importing the file and using in python
Python
2 votes260 views2 answers
Pandas if nan, then the row above
Python
0 vote220 views1 answer
Read a file and split the words python
Python