HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
To sort QuerySets, Django uses the order_by() method
To sort QuerySets, Django uses the order_by()
method:
Order the the result alphabetically by firstname:
mydata = Members.objects.all().order_by('firstname').values()
In SQL, the above statement would be written like this:
SELECT * FROM members ORDER BY firstname;
By default, the result is sorted ascending (the lowest value first),
to change the direction to descending (the highest value first), use the minus sign (NOT),
-
in front of the field name:
Order the the result firstname descending:
mydata = Members.objects.all().order_by('-firstname').values()
In SQL, the above statement would be written like this:
SELECT * FROM members ORDER BY firstname DESC;
To order by more than one field, separate the fieldnames with a comma in the order_by()
method:
Order the the result first by lastname ascending, then descending on id:
mydata = Members.objects.all().order_by('lastname', '-id').values()
In SQL, the above statement would be written like this:
SELECT * FROM members ORDER BY lastname ASC, id DESC;