Select DISTINCT individual columns in django?

by

One way to get the list of distinct column names from the database is to use distinct() in conjunction with values().

In your case you can do the following to get the names of distinct categories:

q = ProductOrder.objects.values('Category').distinct()
print q.query # See for yourself.

# The query would look something like
# SELECT DISTINCT "app_productorder"."category" FROM "app_productorder"

There are a couple of things to remember here. First, this will return a ValuesQuerySet which behaves differently from a QuerySet. When you access say, the first element of q (above) you’ll get a dictionary, NOT an instance of ProductOrder.

Second, it would be a good idea to read the warning note in the docs about using distinct(). The above example will work but all combinations of distinct() and values() may not.

PS: it is a good idea to use lower case names for fields in a model. In your case this would mean rewriting your model as shown below:

class ProductOrder(models.Model):
    product  = models.CharField(max_length=20, primary_key=True)
    category = models.CharField(max_length=30)
    rank = models.IntegerField()

More Related Contents:

  1. Why does django’s prefetch_related() only work with all() and not filter()?
  2. Django: implementing JOIN using Django ORM?
  3. Django Aggregation: Summation of Multiplication of two fields
  4. How to filter empty or NULL names in a QuerySet?
  5. How to view corresponding SQL query of the Django ORM’s queryset?
  6. Custom QuerySet and Manager without breaking DRY?
  7. Raw SQL queries in Django views
  8. How to limit queryset/the records to view in Django admin site?
  9. Django – filtering on foreign key properties
  10. How to query Case-insensitive data in Django ORM?
  11. Django: ManyToMany filter matching on ALL items in a list
  12. Django query datetime for objects older than 5 hours
  13. Django: Does prefetch_related() follow reverse relationship lookup?
  14. django most efficient way to count same field values in a query
  15. Django Order By Date, but have “None” at end?
  16. Django queryset get exact manytomany lookup [duplicate]
  17. Creating Partial Indexes with Django 1.7
  18. how to write a query to get find value in a json field in django
  19. Extending the User model with custom fields in Django
  20. How to define two fields “unique” as couple
  21. In a django model custom save() method, how should you identify a new object?
  22. Unique fields that allow nulls in Django
  23. Tying in to Django Admin’s Model History
  24. Django custom managers – how do I return only objects created by the logged-in user?
  25. Django: Validate file type of uploaded file
  26. Django data migration when changing a field to ManyToMany
  27. how to show datepicker calendar on datefield
  28. How to perform OR condition in django queryset?
  29. Django query case-insensitive list match
  30. Can a dictionary be passed to django models on create?

Leave a Comment