Jake Barnby 9da4a3260d (refactor): improve advisor module perf, security, and maintainability ...

- Fix N+1 in Reports/XList (51→4 queries) via skipFilters + batch fetch
- Add skipFilters to Reports/Delete and cursor fetch (avoid loading all
  nested insights/CTAs just for ownership check)
- Fix N+1 in deleteReport worker (flat CTA deletion instead of per-insight)
- Add advisor entity cleanup on project deletion (reports, insights, CTAs)
- Remove resourceInternalId, parentResourceInternalId, $permissions from
  Insight response model (internal IDs leak DB internals, permissions unused)
- Remove dead subQueryInsightCTAs filter registration
- Remove stale enum-value comments from platform schema
- Fix _key_dismissedAt index to include projectInternalId
- Fix scope category from 'Other' to 'Advisor'
- Switch action base class from Utopia\Platform\Action to Appwrite\Platform\Action

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

2026-05-13 01:13:37 +12:00

..

account.php

AI review improvements

2025-12-29 13:24:26 +01:00

organization.php

Fix scopes

2026-04-08 10:01:52 +02:00

project.php

(refactor): improve advisor module perf, security, and maintainability

2026-05-13 01:13:37 +12:00