/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 vote145 views1 answer
Tkinter gui grid and frame
Python
0 vote103 views2 answers
Delete duplicates from db django the most efficient way
Python
0 vote160 views1 answer
Take first n row of dictionary python
Python
0 vote150 views1 answer
Defaultdict python inport
Python
0 vote147 views1 answer
Dataframe python diplay 2 tables on same line
Python
18 votes149 views5 answers
Remove n from string python
Python
5 votes134 views3 answers
Write to file python 3
Python
0 vote139 views1 answer
Gpt2 simple restore checkpoint
Python
-1 vote142 views2 answers
Pandas dataframe apply function with multiple arguments
Python
5 votes150 views3 answers
How to coppy a file in python
Python