diff options
Diffstat (limited to 'app')
-rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/UserDao.java | 2 |
1 files changed, 2 insertions, 0 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 cfc9fe13b..e9b9ee65b 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 @@ -35,6 +35,7 @@ public interface UserDao extends GenericDao<User> { " 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 u.localId <> (select b.ownerId from board b where localId = :boardId)" + "ORDER BY u.displayname") LiveData<List<User>> searchUserByUidOrDisplayNameForACL(final long accountId, final long boardId, final String searchTerm); @@ -78,6 +79,7 @@ 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 u.localId <> (select b.ownerId from board b where localId = :boardId)" + "ORDER BY u.displayname " + "LIMIT :topX") LiveData<List<User>> findProposalsForUsersToAssignForACL(long accountId, long boardId, int topX); |