[FIXED] How can I filter a Django query with a list of values?

Issue

I’m sure this is a trivial operation, but I can’t figure out how it’s done.

There’s got to be something smarter than this:

ids = [1, 3, 6, 7, 9]

for id in ids:
    MyModel.objects.filter(pk=id)

I’m looking to get them all in one query with something like:

MyModel.objects.filter(pk=[1, 3, 6, 7, 9])

How can I filter a Django query with a list of values?

Solution

From the Django documentation:

Blog.objects.filter(pk__in=[1, 4, 7])

Answered By – charlax

Answer Checked By – Jay B. (FixeMe Admin)