/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 vote282 views2 answers
Install python 3.9 linux
Python
0 vote276 views1 answer
How to prevent \textbackslash in LaTeX from Python
Python
1 vote264 views1 answer
How to find second maximum element of an array python
Python
0 vote260 views1 answer
\n vs \r python
Python
1 vote264 views1 answer
Parse youtube video id from youtube link python
Python
38 votes276 views2 answers
Python create new folder if not exist
Python
0 vote259 views1 answer
Python get the last element from the list
Python
0 vote260 views1 answer
Pandas save dataframe with list
Python
3 votes281 views3 answers
Pil save image
Python
54 votes261 views3 answers
Python add up values in list
Python