/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 vote117 views1 answer
Python skip input
Python
2 votes130 views3 answers
Python split string size
Python
0 vote118 views1 answer
Calculate the euler totient of a number python
Python
0 vote270 views1 answer
OpenPyXl Get Sheet Names
Python
5 votes120 views2 answers
Put comma in numbers python
Python
-1 vote105 views1 answer
Python all any example
Python
0 vote115 views1 answer
Flask where to put db.create_all
Python
0 vote106 views2 answers
Json to base64 python
Python
0 vote116 views1 answer
Can i register a list in python for input
Python
0 vote115 views1 answer
IndexError: tuple index out of range
Python