kolaenteandkolaente e7b693c788 fix(tasks): include tasks with deleted parents in subtask-expanded queries ...

When expand[]=subtasks is used, the LEFT JOIN on task_relations filters
out same-project subtasks. If a parent task was deleted, the JOIN
produces NULL for parent_tasks.id/project_id, and since NULL != value
evaluates to NULL (not TRUE) in SQL, these tasks were incorrectly
excluded.

Add builder.IsNull{"parent_tasks.id"} to the OR condition so tasks
whose parent was deleted are still included in results.

2026-04-02 16:30:23 +00:00

14 KiB

Raw Permalink Blame History

View Raw