Django: Order_by multiple fields

django django-orm
danny picture danny · Apr 12, 2016 · Viewed 35.7k times · Source

I am getting order_by fields in the form of a list. I want to order_by by multiple fields with django orm. List is like below:

orderbyList = ['check-in','check-out','location']

I am writing a query is like: 

modelclassinstance.objects.all().order_by(*orderbyList)

Everything i am expecting in a list is dynamic. I don't have predifined set of data.Could some tell me how to write a django ORM with this?

Answer

burning picture burning · Apr 12, 2016

Try something like this

modelclassinstance.objects.order_by('check-in', 'check-out', 'location')

You don't need .all() for this

You can also define ordering in your model class

something like

class Meta:
       ordering = ['check-in', 'check-out', 'location']

Related questions

How to perform OR condition in django queryset?

I want to write a Django query equivalent to this SQL query: SELECT * from user where income >= 5000 or income is NULL. How to construct the Django queryset filter? User.objects.filter(income__gte=5000, income=0) This doesn't work, because it …

Read More
Django values_list vs values

In Django, what's the difference between the following two: Article.objects.values_list('comment_id', flat=True).distinct() vs Article.objects.values('comment_id').distinct() My goal is to get a list of unique comment ids under each Article. I've …

Read More
What's the difference between select_related and prefetch_related in Django ORM?

In Django doc, select_related() "follows" foreign-key relationships, selecting additional related-object data when it executes its query. prefetch_related() does a separate lookup for each relationship, and does the "joining" in Python. What does it mean by "doing the joining …

Read More