/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 vote239 views1 answer
Django model custom field
Python
-1 vote230 views1 answer
Web browser api python
Python
4 votes224 views3 answers
Txt to list python
Python
52 votes275 views2 answers
Python - remove duplicate items from the list
Python
46 votes233 views6 answers
Get full path of file python
Python
0 vote258 views1 answer
Conda install pypy
Python
0 vote239 views1 answer
Datetime column only extract date pandas
Python
1 vote252 views1 answer
Discord.py message user
Python
0 vote281 views2 answers
Pandas weighted average groupby
Python
3 votes236 views1 answer
Json not readable python
Python