diff options
author | desperateCoder <echotodevnull@gmail.com> | 2019-10-19 23:38:06 +0300 |
---|---|---|
committer | desperateCoder <echotodevnull@gmail.com> | 2019-10-19 23:38:06 +0300 |
commit | 876594892a307d0623a5ec837e2f23b3cd2555d2 (patch) | |
tree | 7e671dc2ed3d44cdad0c2c6ad0fb76e2c27fa9d1 /app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db | |
parent | 7ab0e6cfc15a271368679e51b2298ae9cb7f1ce7 (diff) |
#148: proper sorting for ACL-search
Diffstat (limited to 'app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db')
-rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/UserDao.java | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/UserDao.java b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/UserDao.java index ae2db5652..cfc9fe13b 100644 --- a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/UserDao.java +++ b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/UserDao.java @@ -34,7 +34,8 @@ public interface UserDao extends GenericDao<User> { " select 1 from accesscontrol ju" + " where ju.userId = u.localId and ju.boardId = :boardId and status <> 3" + // not LOCAL_DELETED " ) " + - "and ( uid LIKE :searchTerm or displayname LIKE :searchTerm or primaryKey LIKE :searchTerm )") + "and ( uid LIKE :searchTerm or displayname LIKE :searchTerm or primaryKey LIKE :searchTerm ) " + + "ORDER BY u.displayname") LiveData<List<User>> searchUserByUidOrDisplayNameForACL(final long accountId, final long boardId, final String searchTerm); @Query("SELECT * FROM user WHERE accountId = :accountId and uid = :uid") |