diff options
author | Oguz Kocer <oguz.kocer@automattic.com> | 2016-08-02 17:06:55 +0300 |
---|---|---|
committer | Oguz Kocer <oguz.kocer@automattic.com> | 2016-08-02 17:06:55 +0300 |
commit | 9ce6c438b1f7519c7a1bb9c943b87c0e7d4ae1d8 (patch) | |
tree | 4ea488547e2e3a6e626eed45a0cae69de4524591 /WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java | |
parent | 093545d4eb1ed2e637016674439e7901ebeecd1d (diff) | |
download | gradle-perf-android-medium-9ce6c438b1f7519c7a1bb9c943b87c0e7d4ae1d8.tar.gz |
Fixes multi-order query for PeopleTable
Diffstat (limited to 'WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java')
-rw-r--r-- | WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java index 6e89dba3f..a7ea50c59 100644 --- a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java +++ b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java @@ -314,7 +314,8 @@ public class PeopleTable { // order is disabled for followers & viewers for now since the API is not supporting it private static String orderByString(String table, boolean isDescending) { if (table.equals(TEAM_TABLE)) { - return " ORDER BY lower(display_name), lower(user_name)" + (isDescending ? " DESC" : ""); + String descQuery = (isDescending ? " DESC" : ""); + return " ORDER BY lower(display_name)" + descQuery + ", lower(user_name)" + descQuery; } return ""; } |