How to filter a django queryset using an array on a field like SQL's "IN"?

django django-queryset
mikec picture mikec · Oct 25, 2010 · Viewed 24.7k times · Source

I'd like to filter a Django queryset using an array as a constraint on a field. AKA, my array, for example, a set of primary keys. I want to get only the objects that would be in that array, like the query in SQL would be:

SELECT * from table where id in [1,3,4,5,6....];

Answer

Ignacio Vazquez-Abrams picture Ignacio Vazquez-Abrams · Oct 25, 2010 
.filter(id__in=[1, 3, 4, 5, 6....])

Read more about it at Django docs.

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