diff options
| author | desperateCoder <echotodevnull@gmail.com> | 2024-01-16 14:36:14 +0300 |
|---|---|---|
| committer | desperateCoder <echotodevnull@gmail.com> | 2024-01-16 14:36:14 +0300 |
| commit | 65cde2b196408fe3db9a328db8579e2d25273c0b (patch) | |
| tree | 3b48bc3fe1e3bf1196274f4572b847feb376e26e | |
| parent | b5dd1dfa855eeee347d5206c55666afe22660034 (diff) | |
#1556 mark card as done: hide done cards in upcoming-cards view
| -rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/database/dao/CardDao.java | 1 |
1 files changed, 1 insertions, 0 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 d3d6f4060..dbd0d6315 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,6 +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 " + // 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) |