diff options
author | Stefan Niedermann <info@niedermann.it> | 2024-01-16 15:41:36 +0300 |
---|---|---|
committer | Stefan Niedermann <info@niedermann.it> | 2024-01-16 15:41:36 +0300 |
commit | 3b5301c01f72ddf603045ef1b51ebc98b89d4dfe (patch) | |
tree | 349a93b3586cc3c15599d8eefa2d085c973dd54b | |
parent | 65cde2b196408fe3db9a328db8579e2d25273c0b (diff) |
feat(done): Also filter cards which are done at timestamp 0 for Upcoming cards
Safety first.
Refs: #1556
Signed-off-by: Stefan Niedermann <info@niedermann.it>
-rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/database/dao/CardDao.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/src/main/java/it/niedermann/nextcloud/deck/database/dao/CardDao.java b/app/src/main/java/it/niedermann/nextcloud/deck/database/dao/CardDao.java index dbd0d6315..0f067381e 100644 --- a/app/src/main/java/it/niedermann/nextcloud/deck/database/dao/CardDao.java +++ b/app/src/main/java/it/niedermann/nextcloud/deck/database/dao/CardDao.java @@ -23,7 +23,7 @@ public interface CardDao extends GenericDao<Card> { "and (c.deletedAt is null or c.deletedAt = 0) " + "and (s.deletedAt is null or s.deletedAt = 0) " + "and (b.deletedAt is null or b.deletedAt = 0) " + - "and c.done is null " + + "and (c.done is null or c.done = 0) " + // Full Logic: (hasDueDate AND isIn_PRIVATE_Board) OR (isInSharedBoard AND (assignedToMe OR (hasDueDate AND noAssignees))) "and (" + "(c.dueDate is not null AND NOT exists(select 1 from AccessControl ac where ac.boardId = b.localId and ac.status <> 3))" + //(hasDueDate AND isInPrivateBoard) |