mikec
mikec

Reputation: 3673

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

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....];

Upvotes: 43

Views: 46809

Answers (1)

Ignacio Vazquez-Abrams
Ignacio Vazquez-Abrams

Reputation: 798526

.filter(id__in=[1, 3, 4, 5, 6....])

Read more about it at Django docs.

Upvotes: 75

Related Questions