/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

14 votes171 views2 answers
Django static files / templates
Python
15 votes132 views6 answers
Dataframe to list
Python
2 votes141 views1 answer
Comparing file content in python
Python
0 vote146 views1 answer
How to change speed in ursina
Python
5 votes171 views3 answers
Render to response django
Python
0 vote132 views1 answer
Sum values
Python
0 vote128 views1 answer
Name 'plt' is not defined
Python
1 vote132 views2 answers
Where
Python
0 vote127 views1 answer
How to remove duplicate files from folder with python
Python
101 votes89 views10 answers
Read files python
Python