Django - Unique list from QuerySet

django django-queryset
Hanpan picture Hanpan · Apr 20, 2011 · Viewed 29.3k times · Source

I have a filtered QuerySet which has a ManyToMany field 'Client'. I want to create a unique dict of all the Client objects in the query set so:

Projects Queryset:
- Project1.client = <Client: 1>
- Project2.client = <Client: 1>
- Project3.client = <Client: 2>
- Project4.client = <Client: 2>
- Project5.client = <Client: 3>

class Project(models.Model):
    client = models.ForeignKey(Client, blank=True, null=True)

I want to end up with a dict of client objects:

{<Client: 1>,<Client: 2>,<Client: 3>}

Some help would be appreciated :)

Answer

Yuval Adam picture Yuval Adam · Apr 20, 2011 
Project.objects.values('client').distinct()

Link to Django docs on queryset distinct() method

Related questions

How do I do a not equal in Django queryset filtering?

In Django model QuerySets, I see that there is a __gt and __lt for comparative values, but is there a __ne or != (not equals)? I want to filter out using a not equals. For example, for Model: bool a; int …

Read More
Filtering for empty or NULL names in a queryset

I have first_name, last_name & alias (optional) which I need to search for. So, I need a query to give me all the names that have an alias set. Only if I could do: Name.objects.filter(alias!="") …

Read More
How to combine two or more querysets in a Django view?

I am trying to build the search for a Django site I am building, and in that search, I am searching in 3 different models. And to get pagination on the search result list, I would like to use a generic …

Read More