Retrieving elements in a specific order in django

If you have a list of ordered ids and you want to turn them into an ordered result set you can use FIELD() in mysql:

SELECT * FROM addons
ORDER BY FIELD(id, 3, 5, 9, 1);

This is a handy trick if you use an external search engine which gives you an ordered list of ids and you want to pull out entire row sets.

ids = [a_list, of, ordered, ids]
addons = Addon.objects.filter(id__in=ids).extra(
        select={'manual': 'FIELD(id,%s)' % ','.join(map(str,ids))},
        order_by=['manual'])

Читайте також:

• django postgresql та SCHEMA для таблиць
• Use custom admin filters in ModelAdmin
• MemcachedKeyLengthError: Key length is > 250
• Django yandex and google maps integration
• django-mptt деревоподібний select
• Django mongoengine cache backend
• Python + CouchDB
• Django admin filter by ranges of ages
• How to expire session on browser close in django
• MySQL bin файли займають багато дискового простору

coded by nessus