How can I order the results of Query using more than 1 property?
For example, I want to order my Query results by 'lastname' and order by 'firstname' in each group of 'lastname'.
+1
A:
Just use two orders separated by comma, e.g.:
SELECT * FROM person ORDER BY lastname, firstname
See here for more details.
Aviad Ben Dov
2009-08-15 12:21:31
but it's GqlQuery not Query
Oleksandr Bolotov
2009-08-15 12:28:39
I can use GqlQuery instead, but I wonder if Query supports this kind of ordering in any way. I could not find any example on the API documentation.
Kei
2009-08-15 13:45:39
Oh, I didn't get that from the question... Did you try `.order("lastname, firstname")`?
Aviad Ben Dov
2009-08-15 14:58:28
That does not seem like a valid argument for order. I'll use GqlQuery and move on. Thanks for the help!
Kei
2009-08-16 01:32:06
+2
A:
Have you tried:
Person.all().order("lastname").order("firstname")
Oleksandr Bolotov
2009-08-15 12:37:51
Surely that's a bug, then. http://code.google.com/appengine/docs/python/datastore/queryclass.html#Query_order says "Adds an ordering for the results. Results are ordered starting with the first order added".
Steve Jessop
2009-08-16 18:51:48
Works For Me. This is pretty basic functionality - you can definitely chain order clauses like this.
Nick Johnson
2009-08-17 12:20:47