CODEWITHSUNDEEP
djangodjango-modelsdjango-queryset
amirouche
amirouche

Reputation: 7873

How do get the different values that takes an attribute with a django query?

I have this Model in django :

class Post(models.Model):
    title = models.CharField(max_length=255)
    category = models.CharField(max_length=255)

I would like to get the different values that are used in the category attribute.

For example, if we consider this db :

Post(title = "title 1", category="foo")
Post(title = "title 2", category="bar")
Post(title = "title 3", category="foo")

the query should give me ("foo", "bar")

Upvotes: 0

Views: 99

Answers (1)

Felix Kling
Felix Kling

Reputation: 816364

Use distinct() and values_list():

Post.objects.values_list('category', flat=True).distinct();

Upvotes: 2

Related Questions