diff options
author | desperateCoder <echotodevnull@gmail.com> | 2021-04-09 21:07:02 +0300 |
---|---|---|
committer | Niedermann IT-Dienstleistungen <stefan-niedermann@users.noreply.github.com> | 2021-04-10 14:38:50 +0300 |
commit | a5ef1b4930cb7bef7499fe2fce32b9a5cd02d171 (patch) | |
tree | a7e7a499368622eb4b1e283d5b53f53701a95bc4 | |
parent | 8471e7c2f0fa1a8a49e08a31c7891d6bef0b5738 (diff) |
#690 fixed sql
-rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/CardDao.java | 2 |
1 files changed, 1 insertions, 1 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 607f2ad2e..9a7b88499 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 @@ -23,7 +23,7 @@ public interface CardDao extends GenericDao<Card> { "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 (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))))" + + "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 a.userName from Account a))))" + "ORDER BY c.dueDate asc") LiveData<List<FullCard>> getUpcomingCards(); |