/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 vote192 views1 answer
Scikit learn library in python
Python
19 votes180 views1 answer
Transform size of picture pygame
Python
6 votes180 views2 answers
Python reverse words and swap case
Python
5 votes221 views2 answers
Python Text Recognition
Python
68 votes186 views6 answers
Create a directory python
Python
1 vote194 views1 answer
Write data to using pickle
Python
1 vote198 views1 answer
LookupError: unknown encoding: idna python
Python
4 votes357 views1 answer
Get prime number python
Python
0 vote178 views1 answer
Inverse box-cox transformation python
Python
7 votes219 views2 answers
Ckeditor django
Python