kolaente ac853537e9 fix(tasks): make subtask root condition NULL-safe and search-aware ...

When expanding subtasks, a task was excluded from the roots via NOT over
LEFT-JOINed parent columns. Any filter predicate evaluating to NULL on
the parent row (e.g. due_date <= X with a dateless parent) made the
whole condition NULL, silently dropping the child from the result — it
was neither a root nor nested anywhere. This hit saved filters, list
views with date filters and the gantt view by default.

Rebuild the root condition as a correlated NOT EXISTS subquery, where a
NULL predicate collapses to a clean FALSE, and mirror the free-text
search into the parent predicate so searching for a subtask by title no
longer hides it when its parent does not match the search.

2026-07-15 19:31:14 +02:00

..

admin_actions_test.go

feat: audit admin user and project mutations

2026-07-03 16:56:03 +00:00

admin_bypass_test.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

admin_bypass.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

admin_overview.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

admin_project_list.go

feat: audit admin user and project mutations

2026-07-03 16:56:03 +00:00

admin_user_actions.go

feat: audit admin user and project mutations

2026-07-03 16:56:03 +00:00

admin_user_create.go

feat: audit admin user and project mutations

2026-07-03 16:56:03 +00:00

api_routes_test.go

fix(api): export api-token permission groups in snake_case

2026-06-27 15:01:54 +00:00

api_routes.go

fix(api): export api-token permission groups in snake_case

2026-06-27 15:01:54 +00:00

api_tokens_expiry_cron_test.go

test: add tests for API token expiry notifications and cron

2026-03-30 12:28:15 +00:00

api_tokens_expiry_cron.go

test: add tests for API token expiry notifications and cron

2026-03-30 12:28:15 +00:00

api_tokens_expiry_notification_test.go

test: add tests for API token expiry notifications and cron

2026-03-30 12:28:15 +00:00

api_tokens_expiry_notification.go

feat: add Atom feed for user notifications with API token auth (#2758)

2026-05-15 17:25:09 +02:00

api_tokens_permissions.go

feat(api): bot token support via /tokens CRUD and bot_users_enabled flag

2026-05-01 14:44:10 +00:00

api_tokens_test.go

feat: add Atom feed for user notifications with API token auth (#2758)

2026-05-15 17:25:09 +02:00

api_tokens.go

feat(events): add auth boundary events

2026-06-12 08:56:08 +00:00

bot_users_permissions.go

feat(models): add BotUser CRUD wrapper

2026-05-01 14:44:10 +00:00

bot_users_test.go

feat(models): add BotUser CRUD wrapper

2026-05-01 14:44:10 +00:00

bot_users.go

feat(api/v2): add bot user CRUD on /api/v2

2026-06-05 08:51:39 +00:00

bulk_task_test.go

…

bulk_task.go

docs(api/v2): tag bulk task fields for the v2 schema

2026-06-09 20:13:02 +00:00

comment_quotes_test.go

feat(comments): treat quoted comment authors as implicit mentions

2026-05-20 21:02:14 +00:00

comment_quotes.go

feat(comments): treat quoted comment authors as implicit mentions

2026-05-20 21:02:14 +00:00

error.go

feat(api/v2): add user data export endpoints

2026-06-17 18:39:38 +00:00

events.go

feat: audit admin reads and denied admin access

2026-07-03 16:56:03 +00:00

export_test.go

fix(export): treat a missing export meta row as no export in the status

2026-06-17 18:39:38 +00:00

export.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

favorites.go

…

kanban_permissions.go

…

kanban_task_bucket_test.go

fix(task): recurring tasks return to original bucket when no default is set (#2806)

2026-07-03 23:18:00 +02:00

kanban_task_bucket.go

fix(task): recurring tasks return to original bucket when no default is set (#2806)

2026-07-03 23:18:00 +02:00

kanban_test.go

…

kanban.go

refactor(tasks): drop in-memory task dedup, rely on unique index

2026-06-17 21:16:41 +00:00

label_permissions.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

label_task_permissions.go

…

label_task_test.go

fix(tasks): bump project and task updated times when task sub-entities change

2026-07-07 11:57:04 +00:00

label_task.go

fix(tasks): bump project and task updated times when task sub-entities change

2026-07-07 11:57:04 +00:00

label_test.go

feat(labels): let bot owners manage labels created by their bots

2026-06-09 11:40:04 +00:00

label.go

docs(api/v2): mark server-controlled label and user fields read-only

2026-05-31 15:27:44 +02:00

link_sharing_permissions.go

fix(link-sharing): resolve share read permission via project id so by-id reads work

2026-06-05 09:17:25 +00:00

link_sharing_test.go

fix(security): validate link share JWTs against DB on every request

2026-04-09 15:38:07 +00:00

link_sharing.go

docs(api/v2): tag LinkSharing fields for the v2 schema

2026-06-05 09:17:25 +00:00

listeners_test.go

fix(tasks): bump project and task updated times when task sub-entities change

2026-07-07 11:57:04 +00:00

listeners.go

fix(tasks): bump project and task updated times when task sub-entities change

2026-07-07 11:57:04 +00:00

main_test.go

…

mentions_test.go

…

mentions.go

…

message.go

feat(api/v2): upload user avatar via multipart

2026-06-02 11:55:25 +00:00

metrics_count_test.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

models.go

test(time-tracking): cover the time_entries model

2026-06-08 13:54:09 +00:00

notifications_database.go

fix(notifications): refresh embedded users when reading notifications

2026-06-17 21:18:04 +00:00

notifications_refresh_test.go

fix(notifications): refresh embedded users when reading notifications

2026-06-17 21:18:04 +00:00

notifications_refresh.go

fix(notifications): log unexpected user refresh failures

2026-06-17 21:18:04 +00:00

notifications_test.go

feat: add Atom feed for user notifications with API token auth (#2758)

2026-05-15 17:25:09 +02:00

notifications.go

feat: add Atom feed for user notifications with API token auth (#2758)

2026-05-15 17:25:09 +02:00

oauth_codes.go

feat: add OAuth 2.0 authorization code model and migration

2026-03-27 23:05:04 +00:00

permissions.go

fix: use correct type for permission error

2026-06-29 17:18:05 +02:00

project_duplicate_test.go

feat(projects): make duplicating shares opt-in (#2932)

2026-06-19 10:15:58 +02:00

project_duplicate.go

feat(projects): make duplicating shares opt-in (#2932)

2026-06-19 10:15:58 +02:00

project_permissions_multiple_teams_test.go

…

project_permissions.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

project_repair_test.go

…

project_repair.go

…

project_team_permissions.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

project_team_test.go

…

project_team.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

project_test.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

project_users_permissions_test.go

…

project_users_permissions.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

project_users_test.go

…

project_users.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

project_view_permissions.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

project_view.go

fix(api/v2): scope project view delete to its parent project

2026-06-01 13:04:34 +00:00

project.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

reaction_permissions.go

…

reaction_test.go

…

reaction.go

docs(api/v2): tag reaction fields for the v2 schema

2026-06-09 21:34:22 +00:00

saved_filter_positions_test.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

saved_filters_permissions.go

…

saved_filters_test.go

…

saved_filters.go

docs(api/v2): tag SavedFilter fields for the v2 schema

2026-06-07 10:40:20 +00:00

sessions_permissions.go

…

sessions.go

fix(auth): build OIDC end-session URL with RP-Initiated Logout params (#2943)

2026-06-19 18:27:33 +02:00

setup_tests.go

test(time-tracking): cover the time_entries model

2026-06-08 13:54:09 +00:00

subscription_permissions.go

…

subscription_test.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

subscription.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

task_assignees_permissions.go

…

task_assignees_test.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

task_assignees.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

task_attachment_permissions.go

…

task_attachment_test.go

fix(files): derive file size from reader at creation boundary

2026-04-09 16:22:56 +00:00

task_attachment.go

fix(api): return 200 instead of 500 when listing attachments on a task with none

2026-07-01 12:42:32 +00:00

task_collection_filter_test.go

fix(filter): accept non-zero-padded dates in task filters

2026-07-13 07:50:32 +00:00

task_collection_filter.go

fix(filter): accept non-zero-padded dates in task filters

2026-07-13 07:50:32 +00:00

task_collection_sort_test.go

…

task_collection_sort.go

docs(search): describe the actual constant-score relevance semantics

2026-07-06 15:45:55 +00:00

task_collection_test.go

fix(tasks): make subtask root condition NULL-safe and search-aware

2026-07-15 19:31:14 +02:00

task_collection.go

feat(search): add explicit relevance sort field

2026-07-06 15:45:55 +00:00

task_comment_permissions.go

…

task_comments_test.go

refactor(events): pass context to DispatchPending directly

2026-06-12 08:56:08 +00:00

task_comments.go

docs(task-comments): trim comments to the non-obvious why

2026-06-03 19:57:26 +00:00

task_delete_cron_test.go

feat(caldav): implement RFC 6578 sync-collection REPORT to sync task deletions

2026-07-07 11:57:04 +00:00

task_delete_cron.go

feat(caldav): implement RFC 6578 sync-collection REPORT to sync task deletions

2026-07-07 11:57:04 +00:00

task_duplicate_test.go

…

task_duplicate.go

feat(api/v2): add task duplicate action (#2815)

2026-06-01 14:13:39 +02:00

task_overdue_reminder_test.go

…

task_overdue_reminder.go

…

task_position_test.go

fix(tasks): prevent position race conditions with atomic upserts and locking (#3098)

2026-07-03 19:58:39 +02:00

task_position.go

fix(tasks): prevent position race conditions with atomic upserts and locking (#3098)

2026-07-03 19:58:39 +02:00

task_relation_authz_test.go

fix: use recursive CTE in accessibleProjectIDsSubquery for inherited project permissions

2026-04-05 12:20:35 +00:00

task_relation_permissions.go

…

task_relation_test.go

…

task_relation.go

docs(api/v2): tag task relation fields for the v2 schema

2026-06-09 20:42:00 +00:00

task_reminder_test.go

…

task_reminder.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

task_search_bench_test.go

refactor(tasks): drop in-memory task dedup, rely on unique index

2026-06-17 21:16:41 +00:00

task_search_test.go

chore(search): consolidate scoring comments and deduplicate test helpers

2026-07-06 15:45:55 +00:00

task_search.go

fix(tasks): make subtask root condition NULL-safe and search-aware

2026-07-15 19:31:14 +02:00

task_unread_statuses.go

…

tasks_permissions.go

refactor(models): remove *Arr helper fields now handled by normalizer

2026-05-31 12:56:57 +00:00

tasks_test.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

tasks.go

feat(caldav): implement RFC 6578 sync-collection REPORT to sync task deletions

2026-07-07 11:57:04 +00:00

team_members_permissions.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

team_members_test.go

…

team_members.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

team_sync.go

…

teams_permissions_test.go

…

teams_permissions.go

feat(permissions): site admins bypass all Can* checks (license-gated)

2026-04-20 18:55:06 +00:00

teams_test.go

…

teams.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

time_tracking_filter.go

feat(tasks): soft-delete tasks with permanent deletion after 30 days (#3119)

2026-07-07 11:38:33 +02:00

time_tracking_test.go

refactor(events): pass context to DispatchPending directly

2026-06-12 08:56:08 +00:00

time_tracking.go

fix(time-tracking): reject inverted time-entry intervals

2026-06-08 13:54:09 +00:00

unsplash.go

…

user_delete_test.go

fix(models): allow user-delete cascade to complete for disabled creators

2026-05-06 16:08:16 +02:00

user_delete.go

feat(models): add BotUser CRUD wrapper

2026-05-01 14:44:10 +00:00

user_list_test.go

feat(user): always include own bots in user search

2026-05-01 14:44:10 +00:00

user_project_test.go

…

user_project.go

refactor(user): share user-search logic between v1 and v2

2026-06-11 20:07:43 +00:00

user_settings.go

feat(pro): admin password reset for existing users (#3085)

2026-07-02 19:39:00 +02:00

users.go

fix(notifications): use full user so notifications show display name

2026-06-18 20:57:05 +00:00

webhooks_permissions.go

…

webhooks.go

feat(api/v2): add user webhooks on /api/v2

2026-06-10 19:12:41 +00:00