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?
When you have list of items and you want to check the possible values from the list then you can't use
The sql query will be like
SELECT * FROM mytable WHERE ids=[1, 3, 6, 7, 9] which is not true. You have to use
in operator for this so you query will be like
SELECT * FROM mytable WHERE ids in (1, 3, 6, 7, 9) for that Django provide