I want to fetch a list of items in my database, and I have their id ready: my_ids_to_get = [ 1, 3, 2, ]
In mysql I would fetch them like this: SELECT * FROM table WHERE id IN (1, 3, 2) ORDER BY FIELD( id, 1, 3, 2 ) This would preserve their order. Can I build this query with the native django order_by? I can get the objects like this: MyObject.objects.filter(pk__in=my_ids_to_get) But I'm not able to build an order clause to use with it, and their order is not preserved. Do I have to fall back on raw sql to do this? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---