How to rename items in values() in Django?

by

From django>=1.8 you can use annotate and F object

from django.db.models import F

MyModel.objects.annotate(renamed_value=F('cryptic_value_name')).values('renamed_value')

Also extra() is going to be deprecated, from the django docs:

This is an old API that we aim to deprecate at some point in the future. Use it only if you cannot express your query using other queryset methods. If you do need to use it, please file a ticket using the QuerySet.extra keyword with your use case (please check the list of existing tickets first) so that we can enhance the QuerySet API to allow removing extra(). We are no longer improving or fixing bugs for this method.

More Related Contents:

  1. Issue with ManyToMany Relationships not updating immediately after save
  2. How to view corresponding SQL query of the Django ORM’s queryset?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. django-orm case-insensitive order by
  6. Django: implementing JOIN using Django ORM?
  7. Chaining multiple filter() in Django, is this a bug?
  8. List field in model?
  9. How to query Case-insensitive data in Django ORM?
  10. Default image for ImageField in Django’s ORM
  11. Django ORM: Group by and Max
  12. Django: ManyToMany filter matching on ALL items in a list
  13. How to use custom manager with related objects?
  14. Django queryset get exact manytomany lookup [duplicate]
  15. Creating Partial Indexes with Django 1.7
  16. Saving Many To Many data via a modelform in Django
  17. Why does DEBUG=False setting make my django Static Files Access fail?
  18. Setting DEBUG = False causes 500 Error
  19. Django: How do I redirect a post and pass on the post data
  20. Dynamic File Path in Django
  21. How to ‘bulk update’ with Django?
  22. Use variable as dictionary key in Django template
  23. Django delete FileField
  24. How to handle “matching query does not exist” when getting an object
  25. Django release 1.5: ‘url’ requires a non-empty first argument. The syntax changed in Django 1.5
  26. django most efficient way to count same field values in a query
  27. optimal architecture for multitenant application on django
  28. Sharing models between Django apps
  29. Extending Django Admin Templates – altering change list
  30. How do I display the value of a Django form field in a template?

Leave a Comment