Django values_list vs values

by

The values() method returns a QuerySet containing dictionaries:

<QuerySet [{'comment_id': 1}, {'comment_id': 2}]>

The values_list() method returns a QuerySet containing tuples:

<QuerySet [(1,), (2,)]>

If you are using values_list() with a single field, you can use flat=True to return a QuerySet of single values instead of 1-tuples:

<QuerySet [1, 2]>

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Django – No such table: main.auth_user__old
  3. Django Aggregation: Summation of Multiplication of two fields
  4. How do I do a not equal in Django queryset filtering?
  5. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  6. Django Admin nested inline
  7. “_set” in a queryset object in Django
  8. Nested inlines in the Django admin?
  9. Count number of records by date in Django
  10. Difference between AbstractUser and AbstractBaseUser in Django?
  11. QuerySet, Object has no attribute id – Django
  12. Resize fields in Django Admin
  13. Get the latest record with filter in Django
  14. Django filter JSONField list of dicts
  15. How to delete a record in Django models?
  16. Add custom form fields that are not part of the model (Django)
  17. Can a dictionary be passed to django models on create?
  18. How to properly use the “choices” field option in Django
  19. Django. Override save for model
  20. Django – how to create a file and save it to a model’s FileField?
  21. Python script for Django app to access models without using manage.py shell
  22. Django signals vs. overriding save method
  23. Custom ordering in Django
  24. NoReverseMatch with keyword argument uidb64 with Django 2.0
  25. ‘NOT NULL constraint failed’ after adding to models.py
  26. How to change ForeignKey display text in the Django Admin?
  27. How to put comments in Django templates?
  28. Identify the changed fields in django post_save signal
  29. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  30. Django foreign key relation in template

Leave a Comment