/Python/Django/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

1 vote270 views1 answer
Django datetimefield default
Python Django
0 vote307 views2 answers
How to create template folder in django
Python Django
1 vote252 views1 answer
Django boilerplate command
Python Django
1 vote299 views1 answer
Django genericforeignkey null
Python Django
3 votes274 views6 answers
ImportError: Couldn't import Django. Are you sure it's installed and available on your PYTHONPATH environment variable? Did you forget to activate a virtual environment?
Python Django
1 vote264 views1 answer
Delete and start fresh with db django
Python Django
0 vote268 views1 answer
How to run django server outside world
Python Django
0 vote259 views4 answers
Django-sslserver · PyPI
Python Django
0 vote254 views1 answer
Django many to many post update method via rest
Python Django
0 vote267 views1 answer
How to work with django ornm __in
Python Django