Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/stefan-niedermann/nextcloud-deck.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorStefan Niedermann <info@niedermann.it>2024-01-16 15:41:36 +0300
committerStefan Niedermann <info@niedermann.it>2024-01-16 15:41:36 +0300
commit3b5301c01f72ddf603045ef1b51ebc98b89d4dfe (patch)
tree349a93b3586cc3c15599d8eefa2d085c973dd54b
parent65cde2b196408fe3db9a328db8579e2d25273c0b (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.java2
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)