diff options
author | desperateCoder <echotodevnull@gmail.com> | 2021-04-09 20:03:09 +0300 |
---|---|---|
committer | Niedermann IT-Dienstleistungen <stefan-niedermann@users.noreply.github.com> | 2021-04-10 14:38:50 +0300 |
commit | 796a5554a94fc184d49f46c9829fe6dc9c657ce5 (patch) | |
tree | f7b2f77fd9a2933612d028ce8ea45606092fcec2 | |
parent | dcbfb84ab4877ebea02cffed41068957a416e3e4 (diff) |
#690 enhance SQL
-rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/CardDao.java | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/CardDao.java b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/CardDao.java index 02073c23a..21e2f7475 100644 --- a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/CardDao.java +++ b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/CardDao.java @@ -21,8 +21,8 @@ public interface CardDao extends GenericDao<Card> { "join board b on b.localId = s.boardId " + "WHERE b.archived = 0 and c.archived = 0 and b.status <> 3 and s.status <> 3 and c.status <> 3 " + "and (c.dueDate is not null or exists(select 1 from AccessControl ac where ac.boardId = b.localId and ac.status <> 3))" + - "and (exists(select 1 from JoinCardWithUser j where j.cardId = c.localId and j.userId in (select u.localId from user u where u.uid in (select uid from Account))) " + - "or not exists(select 1 from AccessControl ac where ac.boardId = b.localId and ac.status <> 3))" + + "and (not exists(select 1 from AccessControl ac where ac.boardId = b.localId and ac.status <> 3) " + + "or exists(select 1 from JoinCardWithUser j where j.cardId = c.localId and j.userId in (select u.localId from user u where u.uid in (select uid from Account))))" + "ORDER BY c.dueDate asc") LiveData<List<FullCard>> getUpcomingCards(); |